Count numbers of Month in a cell

  • Thread starter Thread starter Navarat Mishra
  • Start date Start date
N

Navarat Mishra

Dear All:

Please help I have put this formulas to count the times of Months

=SUMPRODUCT((MONTH(B6:B1613)=1)*(YEAR(B6:B1613)=2009)*(INT(B6:B1613)
<>INT(B7:B1614)))

but the result skip the duplicate date, how to solve this problem
please kindly help.

Thanking you in advance for kind help in this matter.

NM
 
Do you mean

=SUMPRODUCT((MONTH(B6:B1613)=1)*(YEAR(B6:B1613)=2009))

--
__________________________________
HTH

Bob









- Show quoted text -
Click to expand...

Yes pls

input msg in column B
1 Jan 09
4 Jan 09
4 Jan 09
6 Jan 09


but by insert the formular as above the result comes 3 for Jan only
bcoz the duplicate of 4 Jan

Thank you.
 
Hi,

If you want the answer to be 4, then please use the following formula

SUMPRODUCT((YEAR(C4:C7)=2009)*(MONTH(C4:C7)=1))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Hi,

If you want the answer to be 4, then please use the following formula

SUMPRODUCT((YEAR(C4:C7)=2009)*(MONTH(C4:C7)=1))

--
Regards,

Ashish Mathur
Microsoft Excel MVPwww.ashishmathur.com










- Show quoted text -
Click to expand...

Thank you

I have tried at home now and it seem to be worked,

I forgot what was the reason to put like that last time.

It is not showing error even there are blank cell.

Tomorrow will try at the office again, if got problem will ask again.

Thank you very much for today.
 
Back
Top