Determine best way to sum

W

WLMPilot

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
 
M

Max

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
---
 
J

JE McGimpsey

Sounds to me like a Pivot Table might be superior to SUMIF/SUMPRODUCT.
PT's will adjust for whatever categories you have listed.
 
W

WLMPilot

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 said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top