Formula Help

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

I am looking for a formula that I can put in a cell to add up all the water
in A1 to A5 that has clean next to it in B1 to B5. Could someone please tell
me how to do this.
a b c d e
1 Water Clean
2 Water Clean
3 Soap Dish
4 Soap Laundry
5 Water Spray
 
=SUMPRODUCT((A1:A5="Water")*(B1:B5="Clean"))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top