Alright it's a little convoluted but stick with me.
I'm working on a motorsports spreadsheet and am trying to count the number of times a race has been held on a date (not including year, so for example how many times there was a race on May 5th).
The formula I have currently is =SUMPRODUCT(--(MONTH($E:$E<>0)=5),--(DAY($E:$E<>0)=1)) and returns 0, which I know to be untrue thanks to a PivotTable I've made that groups the dates in month-day form for me. Adding the range as the first and fourth arrays (=SUMPRODUCT($E:$E,--(MONTH($E:$E<>0)=5),$E:$E,--(DAY($E:$E<>0)=1))) also returns 0, and changing <>0 to <>"" does nothing to the value.
(The reason I'm doing this to begin with is to have the data organized in a calendar-style format)
I'd like to keep the range the entire column of E, so I don't have to continuously update the formula 366 times per race, and I can just input the date of the next race and the calendar update itself. Of course this means I'd like the formula to disclude blanks.
What in the formula is causing the error, and how do I fix it?
Bookmarks