Quarterly totals

[vra]

I HAVE A YEARLY LARGE DATA WITH VARIOUS COLUMNS & DATES. I WANT TO GET QUARTERLY TOTAL & THEN ANNUAL TOTAL. wILL SUBTOTAL USEFUL ...HOW???

 

[Robert Mika]

Hi vra,
Do not write in capital letter - it looks like you shout.

Could you post some of your data?
SUMIF or SUMPRODUCT may work for you.

 

[Roli001]

You could use a Pivot Table to summarize your data. Here is a good tutorial on how to group data to months and quarters using a pivot table:

http://www.youtube.com/watch?v=x2Pp1g4KBkY

Pivot tables are developed specifically for what you are looking to do.

 

[vra]

Sorry for writing in capital letters.
i have excel 2007. The video was for 2003. it did not work in 2007...group option says that section cannot be grouped.
date purchase vat oms
jan01 10000 600
jan 5 8000 300
jan9 9000
As such there is huge data in a year

 

[Roli001]

Here is one for 2007.

http://www.youtube.com/watch?v=8H6DNXsIBNE

 

[vra]

thanks
alot!!!!!!!!

 

[vra]

just one more Q:
if the original sheet gets updated with new data then will the pivot table get automatically updated or give original result only

 

[Robert Mika]

It will give the original results unless you click on pivot and choose Refresh or use a macro:

http://www.mrexcel.com/forum/showthread.php?t=551301&highlight=pivot

 

[vra]

sorry m unable to use pivot table to summarise data quarterly. The group field button does not get enable.

 

[vra]

How to enable the group field button to select quarterly or monthly after inserting pivot table