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)
I have 10 questions, each with various points assigned to themEach question can contains either a Met, Not Met or NAI 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) Read More
