Forum Discussion

busymamabee's avatar
busymamabee
Copper Contributor
Nov 10, 2022

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...
excel
Formulas and Functions
busymamabee's avatar
busymamabee
Copper Contributor
Nov 10, 2022
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?
mathetes's avatar
mathetes
Silver Contributor
Nov 10, 2022

busymamabee 

 

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.]

  • busymamabee's avatar
    busymamabee
    Copper Contributor
    Nov 11, 2022

    mathetes 

     

    I'm fine with multiple ways if I can just find one that works consistantly! It seems like every other time I try to set up a new sheet, I can't use a prior way to get to the updated information I need (because that would be way too easy, of course)

     

    Here is the tab that I'm pulling the data from. Specifically, the dates are the ones listed in Column F (named Closed).

     

     

Resources