Not sure how you define the addujp part, but you could call sumproduct feom
vba
myVal =
Evaluate("SUMPRODUCT((A1:A100=""val1"")*(B1:B100=" "val2"")*V1:C100)")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John W bird via OfficeKB.com" wrote in message
...
I am trying to create a formula to search for 2 different criteria in say
the Ranges 1-100 in Columns A & B and then to add up data in Column C that
is applicable to the identified criteria in Column B.
I should be most grateful for the answer and also is it possible to do the
same exercise with a third criteria?
John
--
Message posted via http://www.officekb.com