Formula help

[Rosemary]

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

 

[FSt1]

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

 

[T. Valko]

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)

 

[Rosemary]

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

 

[T. Valko]

You're welcome. Thanks for the feedback!