Hello,
I have a sheet with data that is organized by program. For each program I
have a subtotal. At the very top I add up all the subtotals to a grand total.
As the subtotals are non-continuous and not at a regular intervall, I have so
far used a plain Sum function. However, I found an alternative, which is as
follows:
SUM(A1:A500)/2
It works just the same but I do not understand how. Can somebody please
explain?

TIA.
Regards,
Antje Crawford