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