Hi Friends,
In the attached file, I use Sumproduct and text functions to count months within the range E6:E200.
The problem is that the formula counts blank cells and adds them as January. Please what modifications can I make to the formular to ignore blank cells?
Thank you.
This:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
G6=IF($G6<>"",SUMPRODUCT((MONTH($E$6:$E$200)=MONTH($G6&0))*($E$6:$E$200<>"")),"")
Copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks