Help Using COUNTIF

Topic

New Reply

[WSJon5]

Hi there,

I’m sure this is simple, but I can’t figure it out. Please take a look at this Google Sheet:

I’m having trouble with column B. Here’s the formula for B3:

=COUNTIF('2022'!M:M,"I got ghosted")

Instead of manually writing “I got ghosted” in the formula, I need this cell to automatically pull that quoted text from A3.

Ditto for B4: Instead of writing…

=COUNTIF('2022'!M:M,"I got ignored")

…I need B4 to automatically pull “I got ignored” from A4.

Any idea how I can modify the formula?

Thanks so much!

• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.
• This topic was modified 8 months, 1 week ago by WSJon5.

Reply | Quote

Replies

Just put the cell reference instead of the text. For example, B3 should be =COUNTIF(‘2022’!M:M,A3)

1 user thanked author for this post.

WSJon5

Reply | Quote

Thanks so much!

Reply | Quote

A slight improvement:

=COUNTIF(‘2022’!M:M,$A3)

This locks it to column A.

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

1 user thanked author for this post.

WSJon5

Reply | Quote

Even better — thanks a ton!

Reply | Quote