Notes for Excel


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


Fancy Formulas

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.