Forum Discussion

Copper Contributor

Dec 21, 2023

Nested functions IF and SEQUENCE. Is that possible?

I have an excel with members. Once a year we send out an invoice. In column N it states the amount to be invoiced. Not all members should have an invoice, hence some N cells contain no amount. In col...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Dec 21, 2023

hoki_kroki

As variant

=LET(
  range, C3:C12,
  number, SCAN(0, range, LAMBDA(a,v, a+ IF(v="", 0, 1) ) ),
  IF( range = "", "", number)
 )

for

Need to be adjusted for your actual data.