Forum Discussion

Bryan365's avatar
Bryan365
Copper Contributor
Sep 26, 2024

Calculated Column - count and sum if column values contain exact text

I have 10 questions, each with various points assigned to them

Each question can contains either a  Met, Not Met or NA

I want to get the total points for the Mets and the Not Mets

 

I can get the Not Met formula to work but I believe my Met formula is also including Not Mets because "Met" is used.  How can I set up my formula so it only looks at the exact word of Met?

 

This is what I have so far

 

=SUM((IF(NOT(ISERROR(Search("Met",[Question 1]))),10)
+(IF(NOT(ISERROR(Search("Met",[Question 2]))),2)
+(IF(NOT(ISERROR(Search("Met",[Question 3]))),10)

No RepliesBe the first to reply

Resources