Formula error
What is wrong with my formula? =COUNTIF({3P2F_status_2024 Range 1}, "737")
I don't get any error message but it's not counting how many "737" I have?
Answers

Could you share an example of the range you have included in the formula? Without seeing that it is hard to understand if there is an issue with the formula.

Hi @Leighmercado,
If you're just looking for the number 737, you don't need the speech marks (" ") around it, making your formula:
=COUNTIF({3P2F_status_2024 Range 1}, 737)
There are a few other options (you're looking for it as part of a multiselect dropdown, for example), but let us know what the situation is and can tailor the formula as needed!

Hi Leighmercado,
I think that the range that you have selected stores the numeric value as strings so I would suggest that convert them as values with the =VALUE function and then see if it starts reflecting.
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Thank you all! unfortunately, none of this worked for me. the range is a helper column so there's a formula in there:

You could try changing your helper column to = IF(CONTAINS("737",Model@row),1,0)
This will add a 1 if 737 is contained within the Model String and 0 if it doesn't, then instead of Countif, you can use
= Sum([Model2]:[Model2])
This would be a Column Formula and will give you the total number in the column.
However, if you want to have a count incrementally down your column you can use a cell formula
= Sum([Model2]$1:[Model2]@row) and drag the formula to the end of your data.
Hope this gives you a way forward.


It took a bit of trial and error but try changing your helper column formula to
=VALUE(LEFT(Model@row, 3))
And then your Countif should work!

@Gillian C That worked! thank you so much!!
I have one more formula that Im trying to figure out! Hopefully you can help again! :)
=SUMIF({Unenrolled MSN Range 1}, "1", {Unenrolled MSN Range 2}, "2024", {Unenrolled MSN Range 4})
range 4 is a dollar value that Im trying to sum but getting #incorrect argument

I haven't tried this in my own worksheet, but I think you need
= SUMIFS({Unenrolled MSN Range 4}, {Unenrolled MSN Range 1},"1",{Unenrolled MSN Range 2}, "2024")
...your formula has two ranges and two criterion, therefore a SUMIFS rather than SUMIF...which changes the arrangement of the formula

ok, now i dont get an error message but its not adding it up.

Help Article Resources
Categories
Check out the Formula Handbook template!