Hello all,
I have the following formula which gives me the sum of accidents in a specific month:
A1 is the department
B2 is the incident code (e.g. "1p")
A10 is the month (in this case august)
The problem I have is that if an incident occurs on the 1st of the month my formula counts it as two seperate incidents, in two seperate months
For example, on the dummy workbook provided:
a 1p incident, in demolition department, on 1/8/09, is flagged in both july and august.
How to I stop incidents that occur on the 1st of the month from being regarded as occurring in 2 months?
Many Thanks
Rich
p.s. if Donkeyote reads this, I know you said that countif is better then sumproduct but I coundnt get it to work for me!
Bookmarks