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

"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"Kevin" wrote:

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!