Multiple "if" criteria

[John W bird via OfficeKB.com]

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

 

[Bob Phillips]

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)

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?

 

[JJ \(UK\)]

Have you tried CountIF or SumIF?

JJ (UK)

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?