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