Countifs array spilling over

[ramswin]

Hi everyone,

I am trying to count the Position ID (column E in the first screenshot) by a few different requires (column A (by Month), column F, column H, column I and column BE). If you take a look at the formula in the second screenshot, I believe I'm doing it correctly because the right number populates in D26 (122). However, cell E26 next to it is also highlighted and when I try to drag the formula across I get a spill error. I need to drag the formula across because it's counting the specific Position IDs by the month in row 18 at the top of the screenshot. Can someone please assist? Much appreciated! (I'm not beholden to that Countifs formula either so if there is a better way I'm open to it).

 

[Fluff]

You need to wrap the formula in SUM.

 

[ramswin]

You need to wrap the formula in SUM.

Fluff you've done it again. Thank you! Out of curiosity why does that work?

 

[Fluff]

Because you have an array for the criteria, you need to add the results together.