• 464K Members
• 11.4K Online
• 560K Conversations

## Sum

Occasional Contributor

# 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 in column C until column B is over \$0.00.

4 Replies

# Re: Sum

Please clarify, you want to sum column (which one) if only  A and B are greater than zero in the row, or you'd like A1+B1 in C1 if both A1>0 and B1>0?

# Re: Sum

Yes, I only want a sum in Column C if both A1>0 and B1>0?

# Re: Sum

Hi,

You can use IF function in addition to OR function to get that done.

So, try this formula in cell C1:

`=IF(OR(A1<=0,B1<=0),"",SUM(A1:B1))`

You can translate the above formula as follows:

If whether cell A1 or Cell B1 is less than or equal to 0, then show nothing, otherwise apply the SUM.

Hope that helps

# Re: Sum

It could be

`=IF((A1>0)*(B1>0),A1+B1,"")`
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies