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

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!

Paul Newcome

Remove the quotes and drop the dollar sign. Then format the column as currency. This should work for you.