Conditional CountIf Question (asked different way)

[Kevin]

1/1/2010 N/A
1/3/2010 Something
2/4/2010 Something
2/5/2010 N/A
2/9/2010 Something
2/22/2010 Something
5/10/2010 Something

What formula will count all the dates in Febuary that don't have N/A in
Column B? So the formula should return a value of 3. Thanks in advance!

 

[Bob Umlas]

=SUMPRODUCT(--(MONTH(A1:A7)=2),--(B1:B7<>"N/A"))
Bob Umlas
Excel MVP

 

[Jim Thomlinson]

Assuming your N/A are actually #N/A returned from a formula then
=SUMPRODUCT(--(MONTH(A1:A7)=2), --(NOT(ISNA(B1:B7))))

else if they are text "N/A" then
=SUMPRODUCT(--(MONTH(A1:A7)=2), --(B1:B7<>"N/A"))

Like I said SumProduct...

 

[Kevin]

Thanks. I looked at that webpage but couldn't figure it out. Appreciate the
help!!

 

[Kevin]

Out of curiosity, what do the '--' do? I've never seen 2 dashes in a row

 

[Jim Thomlinson]

Take another crack at that web page. It takes a bit of time to wade through
it but it's worth it.

 

[Kevin]

Will do. Also, I noticed you can only do this up to about 25 rows before you
get an error (I guess that's the 255 array thing). Any way to get around that
besides creating 4 of them (if you have 100 rows)?

 

[Jim Thomlinson]

coerces true / false into 1 / 0...