Multiple "if" criteria
 

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

Multiple "if" criteria
 

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

Multiple "if" criteria
 

Have you tried CountIF or SumIF?

JJ (UK)

"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