Notes for Excel

Formatting

Accounting is best, this shows zero values as blank,

$(* #,##0.00);(* (#,##0.00);;(@_)

For conditionally highlighting every other row, if they have contents, here's the formula

=AND(MOD(ROW(REF),2),NOT(ISBLANK(REF)))

If you're looking to sum numbers by column or by row for a dynamic array, BYCOL and BYROW is the formula you're looking for.

Stacking arrays is VSTACK or HSTACK, you'll get a bunch of errors if you stack mismatched arrays though.