Countifs Formula

[Sparda142]

Hello,

I'm looking to get the count of the number of times a month within a year is listed in 2 tabs in excel.

Column BU tab in Gone is the Months in the formula
Column BV tab in Gone is the Years in the formula


Column P in ISRs tab is the Months in the formula
Column Q in ISRs tab is the Years in the formula

=COUNTIFS(Gone!BU16:BU550,3,Gone!BV16:BV550,"=2019",ISRs!P3:P78,3,ISRs!Q3:Q78,"=2019")

 

[Special-K99]

Are you saying its not working, cos all youve stated so far is what youve done and no result of what problem you have.

If it's not working try

=COUNTIFS(Gone!BU16:BU550,3,Gone!BV16:BV550,2019,ISRs!P3:P78,3,ISRs!Q3:Q78,2019)

 

[Sparda142]

Sorry for the delay on a response. Yes the formula wasn't working. The formula you have provided me does work. Thanks for all the help.