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!!

"Duke Carey" wrote:

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

"maxtrixx" wrote:

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.

"Duke Carey" wrote:

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.