DSUM Problem

[Guest]

Please help !

Following formula : =DSUM($M$2:$V$55,P2,Conditions!$D1:$E2)

Problem:

How to copy formula above to next row and jump the "Conditions!$D1:$E2" criteria 3 rows down to the next criteria range
automatically.

Help with this one would be much appreicated

DSUM funtion needs to have a field names in criteria.

 

[Debra Dalgleish]

You could use SUMPRODUCT instead of DSUM. For example:

=SUMPRODUCT(($M$2:$M$55=D2)*($N$2:$N$55=E2)*($P$2:$P$55))