Hi, I'm trying to write a spreadsheet and I want a calculation but only want to show the result if the number is greater than zero is anyone got the correct syntax for apple numbers?
[Re-Titled by Moderator]
You can try this solution to put at the bottom of the column (in the example in B4), if the sum concerns a column
=IF(B2+B3>0;SUM(B2;B3);”")
Or at the bottom of the line (in the example in D2) if the sum concerns a line
=IF(B2+C2>0;SUM(B2;C2);”")
Hi Greg,
The function SUMIF is your friend.
A table with one Header Row and one Footer Row:
Formula in Footer cell A8 is SUMIF(A,">0")
Please call back with questions if your table is different.
Regards,
Ian.
thanks I will give that a try :)
How to display sum if number is greater than zero in Apple Numbers?
