Subtotals for a variable number of rows
Following is my data:
A B C
1 Oranges 6
2 Oranges 5
3 Oranges 7
4 Pomegranates 19
5 Pomegranates 16
C3 should be 18, and C5 should be 35.
Next week there will more more or fewer categories with a variable number of
entities in each.
A macro to accomplish this will save me a lot of time (and errors ??).
--
€śDoubt is uncomfortable, certainty is ridiculous.€ť (Voltaire)
|