Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine best way to sum
I have a worksheet that contains 12 "budgets". More like actual
income/expense. Anyway, each line item in each budget has a category, ie CC for Credit Card Pmts, Gas, Grocery, Income, etc. I want to use either SUMIF or SUMPRODUCT. The catch is I do not know if there was a way to "pick up" each category without the possibility of repeating that category later. Normally, and possibly the only way that I know of, I would have to manually type in a SUMIF/SUMPRODUCT for each category, listing the actual category in the formula. I wanted to try a way that would automatically pick up any new categories, not already listed. Hope that makes sense. Thanks for your help. Les |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine best way to sum
I wanted to try a way that would automatically pick up any new categories,
not already listed. Believe a pivot table would crunch everything out easily (ie produce the uniques listing(s) in the ROW area & in top row [COLUMN area]) with required sums in DATA area. You might want to give it a go. -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "WLMPilot" wrote: I have a worksheet that contains 12 "budgets". More like actual income/expense. Anyway, each line item in each budget has a category, ie CC for Credit Card Pmts, Gas, Grocery, Income, etc. I want to use either SUMIF or SUMPRODUCT. The catch is I do not know if there was a way to "pick up" each category without the possibility of repeating that category later. Normally, and possibly the only way that I know of, I would have to manually type in a SUMIF/SUMPRODUCT for each category, listing the actual category in the formula. I wanted to try a way that would automatically pick up any new categories, not already listed. Hope that makes sense. Thanks for your help. Les |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine best way to sum
Sounds to me like a Pivot Table might be superior to SUMIF/SUMPRODUCT.
PT's will adjust for whatever categories you have listed. In article , WLMPilot wrote: I have a worksheet that contains 12 "budgets". More like actual income/expense. Anyway, each line item in each budget has a category, ie CC for Credit Card Pmts, Gas, Grocery, Income, etc. I want to use either SUMIF or SUMPRODUCT. The catch is I do not know if there was a way to "pick up" each category without the possibility of repeating that category later. Normally, and possibly the only way that I know of, I would have to manually type in a SUMIF/SUMPRODUCT for each category, listing the actual category in the formula. I wanted to try a way that would automatically pick up any new categories, not already listed. Hope that makes sense. Thanks for your help. Les |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine best way to sum
I don't know anything about Pivot Tables, but I am reading up on it to learn.
I do have question (for now). Does it matter if there is data in a single column that are headers, or non-important info. Like I stated, I have 12 budgets listed vertically. Each column of each budget has a header. Will that matter when I pull in that column for the Pivot Table? Thanks, Les "Max" wrote: I wanted to try a way that would automatically pick up any new categories, not already listed. Believe a pivot table would crunch everything out easily (ie produce the uniques listing(s) in the ROW area & in top row [COLUMN area]) with required sums in DATA area. You might want to give it a go. -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "WLMPilot" wrote: I have a worksheet that contains 12 "budgets". More like actual income/expense. Anyway, each line item in each budget has a category, ie CC for Credit Card Pmts, Gas, Grocery, Income, etc. I want to use either SUMIF or SUMPRODUCT. The catch is I do not know if there was a way to "pick up" each category without the possibility of repeating that category later. Normally, and possibly the only way that I know of, I would have to manually type in a SUMIF/SUMPRODUCT for each category, listing the actual category in the formula. I wanted to try a way that would automatically pick up any new categories, not already listed. Hope that makes sense. Thanks for your help. Les |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine best way to sum
Upload a small sample file with dummy data/expected results
using a free filehost, eg: http://www.freefilehosting.net/ then post a link to it here Copy the "direct link" which is generated after you upload, then paste it here in your reply -- Max Singapore http://savefile.com/projects/236895 Downloads:21,000 Files:370 Subscribers:66 xdemechanik --- "WLMPilot" wrote in message ... I don't know anything about Pivot Tables, but I am reading up on it to learn. I do have question (for now). Does it matter if there is data in a single column that are headers, or non-important info. Like I stated, I have 12 budgets listed vertically. Each column of each budget has a header. Will that matter when I pull in that column for the Pivot Table? Thanks, Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the value? | Excel Worksheet Functions | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Worksheet Functions |