Formula help
 

Hi,

We use Windows XP and MS Office 2003.

How can I structure my chart to create formulas as follows:

Three columns in my worksheet are "Pending", "Final", and "Amount". I need
to create three "Totals" cells - one that totals everything in the Amount
column, and two more cells - one that calculates only items that are Pending,
and another that calculates only items that are Final.

The person who created the chart doesn't want to break up the Amount column
- she wants to put an "X" in either the Pending or the Final column; then
those entries that have an "X" in the Pending column get a total in one cell,
and those entries that have an "X" in the Final column get a total in another
cell.

I do hope that explanation wasn't too confusing!

Many thanks in advance for any assistance.

Rosemary

Formula help
 

hi
i'm assuming that your column headers are pending, final and amout in
columns A, B and C.
The total amount formula looks like a streight sum of column C
=sum(C2: C100) Adjust the cell references.
for the pending formula....
=sumif(A2:A100,"X",C2:C100) adjust the cell references
for the final formula
=sumif(B2"B100,"X",C2:C100) again adjust the cell references.


Regards
FSt1


"Rosemary" wrote:

Hi,

We use Windows XP and MS Office 2003.

How can I structure my chart to create formulas as follows:

Three columns in my worksheet are "Pending", "Final", and "Amount". I need
to create three "Totals" cells - one that totals everything in the Amount
column, and two more cells - one that calculates only items that are Pending,
and another that calculates only items that are Final.

The person who created the chart doesn't want to break up the Amount column
- she wants to put an "X" in either the Pending or the Final column; then
those entries that have an "X" in the Pending column get a total in one cell,
and those entries that have an "X" in the Final column get a total in another
cell.

I do hope that explanation wasn't too confusing!

Many thanks in advance for any assistance.

Rosemary

Formula help
 

she wants to put an "X" in either the Pending or the Final column;

Let's assume:

Pending is column A, A2:A100
Final is column B, B2:B100
Amount is column C, C2:C100

For the total amount:

=SUM(C2:C100)

For the pending amount:

=SUMIF(A2:A100,"X",C2:C100)

For the final amount:

=SUMIF(B2:B100,"X",C2:C100)


--
Biff
Microsoft Excel MVP


"Rosemary" wrote in message
...
Hi,

We use Windows XP and MS Office 2003.

How can I structure my chart to create formulas as follows:

Three columns in my worksheet are "Pending", "Final", and "Amount". I
need
to create three "Totals" cells - one that totals everything in the Amount
column, and two more cells - one that calculates only items that are
Pending,
and another that calculates only items that are Final.

The person who created the chart doesn't want to break up the Amount
column
- she wants to put an "X" in either the Pending or the Final column; then
those entries that have an "X" in the Pending column get a total in one
cell,
and those entries that have an "X" in the Final column get a total in
another
cell.

I do hope that explanation wasn't too confusing!

Many thanks in advance for any assistance.

Rosemary

Formula help - thank you
 

Thank you to Bill and FSt1 - this did the trick. Thanks again! Rosemary

"Rosemary" wrote:

Hi,

We use Windows XP and MS Office 2003.

How can I structure my chart to create formulas as follows:

Three columns in my worksheet are "Pending", "Final", and "Amount". I need
to create three "Totals" cells - one that totals everything in the Amount
column, and two more cells - one that calculates only items that are Pending,
and another that calculates only items that are Final.

The person who created the chart doesn't want to break up the Amount column
- she wants to put an "X" in either the Pending or the Final column; then
those entries that have an "X" in the Pending column get a total in one cell,
and those entries that have an "X" in the Final column get a total in another
cell.

I do hope that explanation wasn't too confusing!

Many thanks in advance for any assistance.

Rosemary

Formula help - thank you
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Rosemary" wrote in message
...
Thank you to Bill and FSt1 - this did the trick. Thanks again! Rosemary

"Rosemary" wrote:

Hi,

We use Windows XP and MS Office 2003.

How can I structure my chart to create formulas as follows:

Three columns in my worksheet are "Pending", "Final", and "Amount". I
need
to create three "Totals" cells - one that totals everything in the Amount
column, and two more cells - one that calculates only items that are
Pending,
and another that calculates only items that are Final.

The person who created the chart doesn't want to break up the Amount
column
- she wants to put an "X" in either the Pending or the Final column; then
those entries that have an "X" in the Pending column get a total in one
cell,
and those entries that have an "X" in the Final column get a total in
another
cell.

I do hope that explanation wasn't too confusing!

Many thanks in advance for any assistance.

Rosemary