Countif with Match and Index formula not working

[LauraWork]

hi all

I hope I explain this ok: I have a formula that uses Match and Index to find a column header based on set criteria (something & month) and it works fine with Sumif.

I now need to use a similar formula with countif and I can't get it to work, where have I gone wrong? thanks


=SUMIFS((INDEX('Per site detailed report data'!$AK$2:$EB$30000,,MATCH(($C27&I$5),'Per site detailed report data'!$AK$2:$EB$2,0))),'Per site detailed report data'!$C2:$C30000,'Savings tracker'!$A24)

 

[istiasztalos]

Hi LauraWork,

What would you like to count with the COUNTIF?

The SUMIFS needs a column to sum up that may be different from where you check the criteria, but COUNTIF doesn't need that additional input because it doesn't matter which column you count. If you have tried already, post here your formula attempt, what error you received & what outcome you expected and we can check

Thanks!