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?

=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)

"Bob B" wrote in message
...
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?

Bob,
Thanks so much. What a time saver!

"Bob Phillips" wrote:

=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)

"Bob B" wrote in message
...
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?