Quote:
Originally Posted by Spencer101
Then you simply add another condition.
=SUMPRODUCT((A1:A6="Dog")*(B1:B6=0)*(C1:C6="White "))
For multiple choices you use a + symbol in SUMPRODUCT to represent OR:
=SUMPRODUCT((A1:A6="Dog")*(B1:B6=0)*(C1:C6="Beige ")+(C1:C6="Brown"))
If you need more help post an example workbook as it will make things much easier to tailor make to your needs.
|
Hi there,
Thank you, that solved my problem.
I've seen people use formulas with "--" eg.
=SUMPRODUCT(--(ARRAY1),--(ARRAY2)). And was wondering, why would you do this? And what function does the -- perform?
Similar Threads
Threaded Mode
