Formula Help

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
 
S

Sandy Mann

=SUMPRODUCT((A1:A5="Water")*(B1:B5="Clean"))

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top