Forum Discussion
COUNTIFS by Month Excluding Year
I'm attempting to do a COUNTIFS function based on a date range but want to exclude the year so that the date can be updated easily from one year to the next without having to redo all of the formulas...
I don't think a pivot would work in this case, would it? I need to be able to manually enter the Goal total, and then the difference between the goal and actual totals will update automatically. A pivot could definitely count the actual total for my columns but it can't adjust the Goals and Remaining number, can it?
You raise a good question. Let me back up a bit. What you have shown is the end report (minus those monthly counts); what you've NOT shown is the raw data from which those monthly counts will be taken. Could you give us a glimpse of how that data is arrayed?
There may be yet another way to accomplish this, using COUNT or COUNTA and FILTER.
And there may be other ways still. [One of the delightful, if sometimes confusing, things about Excel is that there are often multiple ways to get from A to B.]