Forum Discussion
If multiple cells are blank return blank, only add if all cells have value
Good morning all and thank you for taking the time to read my post. I'm new to excel and trying to create a document with some values in of my monthly electricity bill (boring I know lol). To...
Another formula for 365 would be
= BYROW(values, LAMBDA(v, IF(AND(v<>""), SUM(v), "")))Not only should this work on row1 values, it would repeat the calculation on all the rows in the range 'values'.