I tried to setup a time sheet which separates weekday and weekend hours with SUMPRODUCT. There are 16 columns for the longest month (December), and it works ok in this condition. When I entered "2" in the month cell for February, I got #VALUE! error due to the blank cells. Thanks in advance for your help!
Bookmarks