Here's a small sample file that demonstrates 3 different setups. Each one
uses basically the same formula.
xSubtotals.xls 17kb
http://cjoint.com/?mgxUzSheMR
My personal preference would be to use Excel's built-in Subtotal feature.
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
Thanks enjoy your brake!
--
Shed2
"T. Valko" wrote:
It depends on how your data is setup.
I'll post a small sample file that demonstrates another method later on
tonight. I'm getting ready to take a break!
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
Thanks Biff! I tried this to a segment and it works for the
subtotaling
woderfully and smooth. It gets a bit busy with all of the labels in
column
A, looks rather duplicative. Unfortunately the items are standard
governmental lables and tough to change into some generic names for
ease
of
'EXCELing'. Also there are something like 60 different item names. Is
there
another way to change this existing spreadsheet in this slick fashion
and
still not do what might be considered as major overhall? Bare in mind
the
rows are about 400 lines.
Thanks Again!
--
Shed2
"T. Valko" wrote:
There are a few ways to do this and it all depends on the setup.
One way that requires a slightly different setup. List the item for
each
sub-item like this:
Screws__Item__Cost
Screws__Item 2__10
Screws__Item 3 __20
Screws__Item 4__30
Nails__Item 6__10
Nails__Item 7__20
Nails__Item 8__30
Let's assume that data is in the range A1:C7
Select the range A1:C7
Goto the menu DataSubtotals
Make these selections in the user form:
At each change in: Screws
Use function: Sum
Add subtotal to: Cost
OK out
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
Thanks Biff and here is my shot at how it might be represented. The
worksheet is about 8 columns wide by about 450 rows long if that
makes
a
difference. I used a SUM funcrtion like this =sum(B5+B10) to
include
only
the subtotals in the columns.
Screws Cost
Item 2 _____10
Item 3 _____20
Item 4 _____30
Sub total _____60
Nails
Item 6 _____10
Item 7 _____20
Item 8 _____30
Sub total _____60
Total ____120
--
Shed2
"T. Valko" wrote:
Once again, can you post an example and the desired result?
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
Thank you very much Biff. I am sorry I had to leave the
discussion
last
evening but I applied your suggestion this morning and it
rendered
exactly
what I desired. I feel rather shallow seeing that the
formulation
was
so
rudimentary and I need not have gone through such elaborate means
to
accomplish my desired result.
Since this is my first exposure into this posting for help
method, I
have
another problem with a budget sheet I am working on. The
challenge
is
I
would like to have totals for subparts within the column but I do
not
want
the intermittent subtotals in the column to misrepresent the
grand
total
for
expenses in the column? I have tried subtotaling but I seem top
need
to
go
through the column and apply the subtotal cells into a long
=sum()
formulation. Do you recommend my initiating a new posting into
the
discussion
arena or is there another recommended method for easily answering
this
delema?
--
Shed2
"T. Valko" wrote:
Try one of these entered in A2 then copied down as needed:
If you only have column B and C to deal with:
=11*(B2+C2)
If you have more than just 2 columns:
=11*SUM(B2:H2)
Where H2 represents the column for Sunday
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
Sheet should look something like this
a b c
1 Cost Monday Tue
2 11 1
3 22 2
4 11 1
5 33 2 1
SO, for each quantity in column b or c I want to multiply
either/or
with
11
to create the cost that days activity.
Is this sufficient clarification?
Shed
Shed2
"T. Valko" wrote:
Can you post an example with the desired result?
--
Biff
Microsoft Excel MVP
"CharlieEcho561" wrote in message
...
I am attempting to derive a number (cost) if eihter of the
two
adjacent
column cells have whole numbers. The cost factor is a
constant
11.
So
I
tried forcing the IF funcion then a combination of IF and
OR
but
once I
suspect I got the formatting correct all I could get were
alpha
characters
in
the cost column. Would someone please direct me how to get
the
numeric
number in the cost colum by multiplying either or both of
the
cells
in
the
subsequent adjacent cells in the row?
Thanks
--
Shed2