On Google Sheets, can't drag my =countif formula down

Hey, me again, unfortunately.

I am trying to drag my countif formula down so that the C4 cell becomes C5 and it populates itself.

When I drag it down it says: Error Array arguments to COUNTIFS are of different size.

Anyone know what I'm getting wrong?


=countifs('Coupler Pull'!$O2:$O,$C4,'Coupler Pull'!$V$2:$V,">="&M$1,'Coupler Pull'!$V$2:$V,"<="&N1,'Coupler Pull'!$V$2:$V,"<>")

The '18' in the N column is correct. I am trying to drag it to the cell below.

Appreciate your help!

Prob.png

Shouldn't this:

&N1

be this:

&N$1

Pete

Also, you should mark your previous thread as Solved, as Trevor asked.

Pete

That hasn't worked unfortunately.. and yes I will do asap!

Thanks. Didn't work unfortunately.

Attach a sample file, rather than a picture of one. The instructions in the yellow banner at the top of the screen explain how you can do this.

Pete

Sorry, I'm at work, hence the speed in which I'm replying. Please forgive me for being impulsive.

I might be able to add a file later, thanks for the headsup.