Please help me with a Conditional Count...
Frustrated Newbie...
What is wrong with the following formula I've created, if I'm trying to
count the number of occurrences in Column B that have 1's next to them AND
have either a "*" or a "Fw:*" in Column At?
A B
FYI 1
FYI 1
FYI
FW: FYI 1
Hi 1
FW: Hi 1
Formula:
=SUMPRODUCT((A1:A6="*")*(A1:A6="Fw*")*(B1:B6=1) )
I would expect to get back a value of 3. I'm getting 0 and no errors.
Thanks!
|