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