Forum Discussion
Sum
I want to add an auto sum but I only want the sum column to enter amounts when a specific column has a dollar amount in it. So, if column A is $524.00 and column B is $0.00, I don't want anything...
Yes, I only want a sum in Column C if both A1>0 and B1>0?
It could be
=IF((A1>0)*(B1>0),A1+B1,"")