Sum if in a column of a "if" formula

Mtmoroni · 03/05/20

I have 1 sheet that has a if statement, looking at a multi choice drop down column. "=IF(CONTAINS("CLEC Phone", [Specific item list]@row), "2", "")

Now, I want to create a metrics sheet based off that sheet to calculate the total of that column that may/may not have "2" in them. However, it appears that it can not add this up, as, I believe, it is 'text' and therefore can not calculate it out.

Is my understanding correct? Is there a way around this at all.

Please let me know if i am missing any details on explaining this.

Mtmoroni · 03/05/20

And since i cant delete this, i finally stumble don teh answer:

IF Statement creating text result, not numeric value

bryan.mcfaden21551

Aug 22, 2017

Looking for guidance....I have an If statement which is creating a text value and not a numeric value, thus it won't allow me to choose those results and sum them up. Any suggestions?

This is the If statement example I have which provides the end result number, but the value appears to be listed as text. Then when I run a SUM total, I get 0 as my end result value

=IF([Technology Relevance]1 = "Y", "10", IF([Technology Relevance]1 = "N", "0"))

Thanks!

I had to remove the " " around my numeric values

Mtmoroni · 03/05/20

And since i cant delete this, i finally stumble don teh answer:

IF Statement creating text result, not numeric value

bryan.mcfaden21551

Aug 22, 2017

Looking for guidance....I have an If statement which is creating a text value and not a numeric value, thus it won't allow me to choose those results and sum them up. Any suggestions?

This is the If statement example I have which provides the end result number, but the value appears to be listed as text. Then when I run a SUM total, I get 0 as my end result value

=IF([Technology Relevance]1 = "Y", "10", IF([Technology Relevance]1 = "N", "0"))

Thanks!

I had to remove the " " around my numeric values

Mike Wilday · 03/05/20

Good find @Mtmoroni that is the reason. 🤓Gotta love the intricacies of spreadsheets.

Formulas and Functions

Formulas and Functions

Sum if in a column of a "if" formula

Best Answer

IF Statement creating text result, not numeric value

Answers

IF Statement creating text result, not numeric value

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Formula - use % complete to determine whether in progress

Formula error

TRYING TO FIND THE ERROR IN THIS FORMULA