Sumproduct with And?

Giganews Newsgroups
Subject: Sumproduct with And?
Posted by:  SteveC
Date: Wed, 17 May 2006


that works.  But:



Basically, I'm trying to add together numbers that match any label in b5:b8

To further explain, and not to confuse the mattter:
so if b5:b8 include apples, bannansas, pears, pineapples, then I can have
sum all these and label this new cell "Fruit"

any suggestions?  thanks very much!