Conditional CountIf Question (asked different way)

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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!
 
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...
 
Take another crack at that web page. It takes a bit of time to wade through
it but it's worth it.
 
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)?
 
Back
Top