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]
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.
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);”")
thanks I will give that a try :)
How to display sum if number is greater than zero in Apple Numbers?
