Ferde,

I dispair that Excel is so anal about data typing. If you have TRUE in a cell, and it's
centered, (presuming you haven't set left, center, or right alignment), then you know that
Excel has typed it as boolean. Your formula won't work because the quotes around "TRUE"
means it's text data type, not boolean. If the TRUE in your cell had been text (such as
with a preceding apostrophe, or having first been formatted for text (before TRUE was
entered into the cell), then your formula would have worked. It's just one more gotcha.

Similar problems occur when Excel has typed a cell as text, but it "looks" like a number.
Happens frequently when numeric data has been pasted in, such as from a web page or other
program. In that case, some formulas will pick up the numbers, and some won't.

The nerds at Excel think users understand data typing, so they designed it with a
programmer's approach, not with a typical end-user's perspective.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"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