View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bud i[_2_] bud i[_2_] is offline
external usenet poster
 
Posts: 1
Default 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)