|Subject:||Sumproduct with And?|
|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!