COUNTIF in Sheet Summary counting things that are not there

Katrina Wheeler

I am a formula novice and I am trying to count the number of instances certain criteria show up in a column. I noticed that it is counting extra things. For example, I know that it should add up to 6, but it is counting 3 extra things that are not there and the result I am getting is 9. Is this the right formula to use for these purposes? If so, what do I need to fix?

If it's the wrong formula, what should I be using?

Here is the formula I am using:

=COUNTIF([Budget/Contract Task]:[Budget/Contract Task], OR(CONTAINS("Site selected", @cell), CONTAINS("Create in AFRU + Portfolio Sheet", @cell), CONTAINS("MOU If new dept", @cell), CONTAINS("Deep Dive", @cell), CONTAINS("Kick-off Meeting", @cell)))

My data in Card view:

Thank you!!

Andrée Starå

Hi @Katrina Wheeler

Strange! It looks correct.

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!