Summing 12 Months of Data Per Account

[qdub]

Hi,

I have a lot of accounts and each account has 12 months of data. I need to find yearly sums for each account. The way my excel chart is oriented right now is there are 12 rows per account (i.e. 1 row per month), but there are a few accounts that have less than 12.

So is there any way to sum 12 months of data for each account in one fell swoop? Right now, I just using the sum function for each account separately, and it is tedious.

Sorry, if this was unclear (my first post).

[TMS]

It would probably serve you well to upload a sample workbook with some typical, but not necessarily real, data. It is difficult to propose a solution without knowing the structure and content of your workbook and/or worksheet.

Regards

[qdub]

Here is a rough idea of what it's like except there are way more than 3 accounts.
And in this case I'm looking for the yearly sum for Usage of X per account.

[TMS]

Cell G2: =IF($A2=$A1,"",SUMIF($A:$A,$A2,E:E))

Copy across and down.


Regards

[qdub]

Thanks, that worked great!

This isn't that important, but is there anyway to move the result so it appears at the end of each account. I.E the first result will appear in G13 instead of G2? If not, this is still fantastic.

[TMS]

Can't test but try changing the first $A1 to $A3

Regards