Using SUMIFS, on a column that displays a $, based of a formula

Options
Mtmoroni
Mtmoroni ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!