Hi all,

I am trying to use DSUM to check 2 different columns of criteria before summing the corresponding data. SUMPRODUCT works great but the data is just too large and the slowdown is unbearable. I have taken a sample off the forum with a simplar problem and worked off it to illustrate what I hope to achieve. In this case, the idea is to determine the sum of the weights for individual names whose height is greater than 5.

The previous example using Sumproduct and DSUM with the entire criteria listed in L1 to M7 is displayed at the top. However, I am hoping to create a formula which I can copy and paste down as new names and new data gets added. I12 shows a working example, but the name criteria has to be locked (H$12) before it works correctly. Ideally, it should be condensed into a DSUM like I19 which references I18 (criteria), and is then pasted down.

Any idea how to work around this?

Thanks alot!

I am trying to use DSUM to check 2 different columns of criteria before summing the corresponding data. SUMPRODUCT works great but the data is just too large and the slowdown is unbearable. I have taken a sample off the forum with a simplar problem and worked off it to illustrate what I hope to achieve. In this case, the idea is to determine the sum of the weights for individual names whose height is greater than 5.

The previous example using Sumproduct and DSUM with the entire criteria listed in L1 to M7 is displayed at the top. However, I am hoping to create a formula which I can copy and paste down as new names and new data gets added. I12 shows a working example, but the name criteria has to be locked (H$12) before it works correctly. Ideally, it should be condensed into a DSUM like I19 which references I18 (criteria), and is then pasted down.

Any idea how to work around this?

Thanks alot!

## Comment