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

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

Wont let me enter this formula, says it contains an error, I suppose that the
Incident numbers will be higher than the date.

Mark

"Dave Peterson" wrote:

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

What formula did you use?

that "whateverelseyouneed" was a place holder for you to put whatever else you
need.

santaviga wrote:

Wont let me enter this formula, says it contains an error, I suppose that the
Incident numbers will be higher than the date.

Mark

"Dave Peterson" wrote:

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


--

Dave Peterson

I did that I put in 01 for month Jan, But cam up with error

Mark

"Dave Peterson" wrote:

What formula did you use?

that "whateverelseyouneed" was a place holder for you to put whatever else you
need.

santaviga wrote:

Wont let me enter this formula, says it contains an error, I suppose that the
Incident numbers will be higher than the date.

Mark

"Dave Peterson" wrote:

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


--

Dave Peterson

What was the formula you used?

santaviga wrote:

I did that I put in 01 for month Jan, But cam up with error

Mark

"Dave Peterson" wrote:

What formula did you use?

that "whateverelseyouneed" was a place holder for you to put whatever else you
need.

santaviga wrote:

Wont let me enter this formula, says it contains an error, I suppose that the
Incident numbers will be higher than the date.

Mark

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson