Thread: Yearly sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jam[_2_] jam[_2_] is offline
external usenet poster
 
Posts: 2
Default Yearly sum


Any help?
I have a column that I want the monthly sum and then the yearly sum,
any way to make it easier?
A B
1 Jan
2 1 100
3 2 150
4 3 260
5 31 100
6 Sum 610
7 Feb 50
8 1 70
9 90
10 28 100
11 sum 310
12
13 December
14 1 100
15 31 150
16 sum 250
17 Year 1170 (=b6+b11+b16)

Thanks in advance
Jam