=CountIfs not working & making simple change

[The Protector]

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

This is my formula. I want to count the cell that the text "outbound" is in, not the word 'outbound' but whenever I remove the "outbound" in the formula and replace it with "C4" which is the cell number/location, it thinks I mean the letter word value "C4". Any help here?

Whenever I go online it just tells me to type in the cell location, but it doesn't work!

Really appreciate some help - many thanks.

Forum ask.png

[Pete_UK]

This is a duplicate thread. Continue with your other thread, where you already have 2 replies.

Pete

[6StringJazzer]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread