Chris:

Please post your formula so we can see what structure you're using.

***********
Regards,
Ron

XL2002, WinXP


"Chris" wrote:

I get an error that stats value not available. I copied the formula and then
simply adjusted the ranges. Does it matter if we're trying to use a
"sumproduct" formula and we're dealing with text? I'm trying to evaluate two
columns of text and they both have to be a "y" to be counted. Thanks.

"Ron Coderre" wrote:

Chris........Try this:

=SUMPRODUCT((K2:K100="Y")*(L2:L100="Y"))

Adjust range references to suit your situation.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Chris" wrote:

I'm trying to come up with a formula that would give me a count of a yes/no
combination in two different columns like below:

K L
1 Member Approved
2 y y
3 y n
4 n y
5 y y

where I can get a count of the "Y" in column K that are also "Y" in column
L, in other words, the members who are also approved. I've tried stringing
two countif formulae together, but can't seem to get that to work. Any
suggestions?