Using SUMIFS, on a column that displays a $, based of a formula
Options
Mtmoroni
✭✭✭✭✭
I am looking at tieing 2 sheets together.
My data sheet has a Column A, that is a check mark or not.
Column B has a formula of "=IF([Column A]1 = 1, "$2"); therefore, it displays "$2"
Column C has a month number, "01"
I want a sumifs to sum all column B. But it display $0, and am assuming its because the formula in column B. If i manually enter "$2", the formula works.
Any help would be great!
Tags:
Comments
-
Remove the quotes and drop the dollar sign. Then format the column as currency. This should work for you.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!