Are those serial numbers always way bigger than any date you need to count?

=sumproduct(--(h2:h22date(2000,1,1)),
--(h2:h22<date(2006,12,31),
--(whateverelseyouneed))

santaviga wrote:

I have the formula below to total the amount of months in date format to be
totalled onto another sheet, Unfortunately this formula also adds totals for
normal numbers input also and is returning false totals for months in dates.
=SUMPRODUCT(--(H2:H22<""),--(ISNUMBER(MATCH(MONTH(H2:H22),{1},0))))
does anyone have any ideas how to solve this formula so it only recognises
12/01/2006 the month 1, and does not recognise numbers input like 1410123 as
this is recognised also and totals.

Anyone any idea,

Thanks

Mark

--

Dave Peterson