conditional sum

B

Bob B

I have source data on one worksheet and a summary in another. I would like
to sum some data if it meets 2 different criteria. The only way I know to do
this is through the conditional sum add-in but it takes too long and cannot
be "dragged down". Is there another easier way?
 
B

Bob Phillips

=SUMPRODUCT(--(Sheet2!A1:A100="test1"),--(Sheet2!B1:B100="Test2"),Sheet2!C1:
C100)

maybe uisng absolute references

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
B

Bob B

Bob,
Thanks so much. What a time saver!

Bob Phillips said:
=SUMPRODUCT(--(Sheet2!A1:A100="test1"),--(Sheet2!B1:B100="Test2"),Sheet2!C1:
C100)

maybe uisng absolute references

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Top