try

=SUMPRODUCT(--(A1:A250="A"),--(B1:B250=0))

"maxtrixx" wrote:

Here is what I'm trying to do, I have two colums with data, the first column
will have one of four letters (A, B, C, D) the second column will have one of
two numbers (0, 1). I need to get 6 different counts:

COUNTIF column A range A1:A250 is A
COUNTIF column A is range A1:A250 B
COUNTIF column A is range A1:A250 C
COUNTIF column A is range A1:A250 D
COUNT column A ONLY IF column B range B1:B250 is 0
COUNT column A ONLY IF cloumn B range B1:B250 is 1

I can do the first 4 calculations pretty easy but am having a hard time
figuring out how to do the last two calculations. Can anyone help me?
Thanks in advance.