Combining IF and COUNTIF based on two columns

[Guest]

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.

 

[Guest]

try

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

 

[Guest]

Awesome, thank you, works like a charm. Now is it possible to include some
date ranges like from 1/1/2005 to 1/31/2005? I need this by month. I forgot
to include that in the original question.

 

[Guest]

Thanks for the feedback.

As for the second question, adjust this formula to reflect your ranges

=SUMPRODUCT(--(A1:A250="A"),--(B1:B250=1),--(MONTH(C1:C250)=1))

Duke

 

[Guest]

Duke,

I understand the MONTH function and it works on individual cells but it
doesn't work inside the SUMPRODUCT function. I have the column where the
dates are formated to Date in the 3/1498 format. Do you know how to get
around this? Thanks again for the quick reply.

 

[Guest]

I cleaned up the column and it worked perfectly. I imported the data from a
text file and some of the fields had a "." in them so that's where the error
was. Thank you very much!!