Refer to the attached spreadsheet on the Summary Day Count tab in cell M13. I would like to add to the SUMPRODUCT formula that I have and say if the appropriate cell in the range $AI$3:$AI$20000 has a blank value then not to include it in the Total # count. Can anyone help with this asap? Thanks a lot!
Bookmarks