Forum Discussion
If formula
Alternative
= LET( s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))), VSTACK(s, SUM(s)) )
Yousef70 GReat, though I don't understand that formula.
Dear Riny
however , it did not work on more than two cells as follows :
=MAX(0,O6,O7,O8,O9,O10,O11,O12,O13,O14,O15,O16,O17,O18,O19,,O20,O21,O22,O23,O24,O25,O26,O27,O28,O29,O30,O31,O32,O33,O34,O35,O36,SUM(O6:O36))
it did only give 1 positive cell result not a sum ( the highest of positive cells not a sum of positive cells )
| -1232.200 | |
| -1013.200 | |
| 573.200 | |
| 620.000 | |
| result cell | 620.000 |
Yousef70 You still have not explained what the result should be and why. The last formula is quite odd and can be shortened to:
=MAX(0,O6:O36,SUM(O6:O36))
Dear Riny ...
sorry for not explaining to you what I am trying to do ( I will try to do my best )
I am doing excel accounting calendar for payments to suppliers ( I am a retailer ) it is like a provision for what should be paid according to date , thus , I have 30 to 31 cells vertical .
if payment is honored it is positive , if a payment is not honored it is negative ( I still need to see it not honored to schedule the payment to a later date but not accounted for in the result )
the needed result is to know total actual paid daily and monthly
I have done that =MAX(0,O6:O36,SUM(O6:O36)) but the result is only the highest positive cell not a sum of positive cellsYousef70 Then you should consider using SUMIF like in the example in the picture below. This will sum only positive amounts.