Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 8th 11, 10:25 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 23
Default Summarize By Category?

I am working with Excel 2003 and W Vista.
I have a spread sheet that contains 5 columns. One column contains
Amounts Spent. Another column contains a one word category of what the
amount was spent on such as fuel, dining etc.
The spreadsheet is in order of the date of the expenditure. Someplace
at the bottom I would like to be able to show sub totals based on the
category.
Thank you for any and all help.

  #2   Report Post  
Old September 8th 11, 10:55 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2011
Posts: 86
Default Summarize By Category?

Check out the features of Pivot Tables.

For very good assistance see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

See help under the "P" section.

For your particular need maybe

http://www.contextures.com/excel-piv...subtotals.html


Gord Dibben Microsoft Excel MVP

On Thu, 8 Sep 2011 14:25:36 -0700 (PDT), trvlnmny
wrote:

I am working with Excel 2003 and W Vista.
I have a spread sheet that contains 5 columns. One column contains
Amounts Spent. Another column contains a one word category of what the
amount was spent on such as fuel, dining etc.
The spreadsheet is in order of the date of the expenditure. Someplace
at the bottom I would like to be able to show sub totals based on the
category.
Thank you for any and all help.

  #3   Report Post  
Old September 13th 11, 01:17 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 23
Default Summarize By Category?

On Sep 8, 5:55*pm, Gord wrote:
Check out the features of Pivot Tables.

For very good assistance see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

See help under the "P" section.

For your particular need maybe

http://www.contextures.com/excel-piv...subtotals.html

Gord Dibben * *Microsoft Excel MVP

On Thu, 8 Sep 2011 14:25:36 -0700 (PDT), trvlnmny
wrote:







I am working with Excel 2003 and W Vista.
I have a spread sheet that contains 5 columns. One column contains
Amounts Spent. Another column contains a one word category of what the
amount was spent on such as fuel, dining etc.
The spreadsheet is in order of the date of the expenditure. Someplace
at the bottom I would like to be able to show sub totals based on the
category.
Thank you for any and all help.


OK, I am using the Pivot Table Wizard. In my source worksheet I have
columns labeled Date, Amount and For.
In the Wizard Layout screen I move Date to Row, I move For to Column
and I move Amount to Data. What happens is Amount changes to Count of
Amount. This gives me a count of the amount entries and not the actual
amount value.
Thanks for any and all help.
  #4   Report Post  
Old September 24th 11, 11:32 AM posted to microsoft.public.excel.newusers
Mad Mad is offline
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2011
Posts: 1
Default Summarize By Category?

trvlnmny wrote:
On Sep 8, 5:55 pm, wrote:
Check out the features of Pivot Tables.

For very good assistance see Debra Dalgleish's site.

http://www.contextures.on.ca/tiptech.html

See help under the "P" section.

For your particular need maybe

http://www.contextures.com/excel-piv...subtotals.html

Gord Dibben Microsoft Excel MVP

On Thu, 8 Sep 2011 14:25:36 -0700 (PDT),
wrote:







I am working with Excel 2003 and W Vista.
I have a spread sheet that contains 5 columns. One column contains
Amounts Spent. Another column contains a one word category of what the
amount was spent on such as fuel, dining etc.
The spreadsheet is in order of the date of the expenditure. Someplace
at the bottom I would like to be able to show sub totals based on the
category.
Thank you for any and all help.


OK, I am using the Pivot Table Wizard. In my source worksheet I have
columns labeled Date, Amount and For.
In the Wizard Layout screen I move Date to Row, I move For to Column
and I move Amount to Data. What happens is Amount changes to Count of
Amount. This gives me a count of the amount entries and not the actual
amount value.
Thanks for any and all help.


Click on the "Count of Amount" and you should be able to change count to sum

Also check out the sumif formula it will total, that may be an
alternative solution


--
Mad



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY sameer Excel Discussion (Misc queries) 2 January 11th 10 01:55 PM
Summarize & Delete littleredhairedgirl Excel Worksheet Functions 0 April 29th 09 01:42 PM
Cant summarize nrs like 15.200,00 Sircantona Excel Discussion (Misc queries) 3 April 29th 08 05:59 PM
Query on Category & Sub-category Santha Kumar Excel Discussion (Misc queries) 1 April 25th 07 12:30 PM
summarize PBark New Users to Excel 3 April 11th 06 04:59 PM


All times are GMT +1. The time now is 06:41 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017