conditional formula using sumproduct
I guess that your TRUE and FALSE are not text strings but Boolean values.
Try deleting the quote marks around TRUE.
In fact as a Boolean you can delete the =TRUE, so the formula simplifies to
=SUMPRODUCT((A2:A6="6N")*(B2:B6))
--
David Biddulph
"ferde" wrote in message
...
A--------------B-
6N FALSE
6N FALSE
7N TRUE
8N TRUE
6N TRUE
I am using this as an array formula in C2 but getting zero for an answer
when the correct answer would be 1. Can anyone tell me what I am doing
wrong. I am looking for the formula to count the number of times "TRUE"
is
found in B2:B6 IF "6N" is also found in A2:A6. Any help would be
greatly
appreciated.
SUMPRODUCT((A2:A6="6N")*(B2:B6="TRUE"))
correct answer =1
|