In Sheet1 (columns B and C), as shown at the attached workbook, I enter values, everyday.
In Sheet2 I sum that values for every month. From the current month (October), I have a SUMIF function to get the total number of the dates that data cells have data (they aren't blanks) so far.
What I want is to copy that function in all cells, for the next years, without change every month the range of COUNTIF.
Thanks in advance
Bookmarks