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
You could try this one (not tested)
=countifs('Coupler Pull'!$O2:$O,$C4,'Coupler Pull'!$V$2:$V,">="&M$1,'Coupler Pull'!$V$2:$V,"<="&N$1,'Coupler Pull'!$V$2:$V,"<>")
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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
Since you got answers of several forummembers it is good to add to whom you replying.
I don't have google sheets, but
"Thanks. Didn't work unfortunately."
What is the failure you get.
You will get better help if you add a small file on the forum, so forummember can test the offered solution.
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.
Your first criteria range isn't anchored properly either:
=countifs('Coupler Pull'!$O$2:$O,$C4,'Coupler Pull'!$V$2:$V,">="&M$1,'Coupler Pull'!$V$2:$V,"<="&$N$1,'Coupler Pull'!$V$2:$V,"<>")
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks