how to short monthwise report

[parbatidebnath]

input output

month amt month amt

may 200 may 200

june 300 june 300

aug 200 july 100

july 100 aug 200

sept 200 sept 200


please help me total monthwise report in excel, how to short this type of monthwise report.


thanks & regards,

Parbati Debnath

 

[Hui]

Parbati


I'm not really sure what you mean by Shorten the report


You can eliminate the second month reference like:

[pre]

input output
month amt month amt
may 200 200
june 300 300
aug 200 100
july 100 200
sept 200 200

[/pre]

You also mention Totals


You can sum the data using =Sum(Range)

eg: =Sum(a2:A10)

adjust accordingly

 

[parbatidebnath]

how can i send an attach excel file?

 

[Hui]

Read the post for instructions: http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[parbatidebnath]

http://www.mediafire.com/view/?134449k7ps2m8n0

 

[SirJB7]

Hi, parbatidebnath!

You can't because column A is a text formatted column. You should change it to a date formatted column with mask "DDD'YY" and then sort range A:B by column A.

Regards!