01-08-2019 10:59 AM
01-08-2019 11:05 AM
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?
01-08-2019 11:09 AM
You can use IF function in addition to OR function to get that done.
So, try this formula in cell C1:
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
by JackPalmer on July 06, 2020
by Bill Jelen on February 26, 2020
Posted in Microsoft Ignite The Tour 2019 on October 10, 2019