Subtotals by column

[gate12390]

Hi there,

I have monthly data by column.
How can I get the annual data using subtotals fuction


Jan Feb Mar .... Dec Year 2009 Jan Feb Mar ... Yr 2010
Sales 10 10 10 120
Profit 8 8 8 80

 

[Useful]

Hi there,

I have monthly data by column.
How can I get the annual data using subtotals fuction


Jan Feb Mar .... Dec Year 2009 Jan Feb Mar ... Yr 2010
Sales 10 10 10 120
Profit 8 8 8 80

Hi
Sumif()-?
(can you be more clearly?)

 

[gate12390]

I have uploaded a picture of what I want to do here:
https://docs.google.com/document/d/1LeOQwZgLpw4L0M5hi9EBBxVp0A_qOwujg5I5MQmM3Yo/edit?hl=en&authkey=CP3VuakF
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
<o> </o>
The excel data is posted at Google docs, here:
https://spreadsheets.google.com/ccc?key=0AnS38ejH2TaQdEJEV1praU5TVENzT1lWNllPZ1g3V0E&hl=en&authkey=CPPBj8MM