Forum Discussion

Yousef70's avatar
Yousef70
Brass Contributor
Jul 19, 2023
Solved

If formula

Dear Sirs …. Kindly need your help with below table to distinguish between + or - numbers in the result cell to take + value cell keep in mind the following If formula used in result cell ( if there...
microsoft 365
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Jul 23, 2023

    Alternative

    = LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jul 23, 2023

Alternative

= LET(
    s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))),
    VSTACK(s, SUM(s))
  )
Yousef70's avatar
Yousef70
Brass Contributor
Jul 25, 2023
Dear Peter …

Many thanks for your input

I didn't get the chance to implement the above coding , I will ASAP and inform you about the results

Resources