Ignore blank cells

No. The blank cell(s) gives "#VALUE!"

Alkey
Thanks.
I think our posts crossed!

Alan

Winon

Just simple numbers - the AGGREGATE function works fine.

Alan

icestationzbra

SUM(SUMIF(INDIRECT({"a1","c1","f1","g1"}),">0"))

That too works, but only for a single row - it cannot be copied down a column unless you do a lot of manual editing.

Regards

Alan