$6,980 x
$11,880
$4,900 x

By putting an "X" in a cell adjacent to a number in a different cell is
there a way for a sheet to add up the cells chosen? Using the example above
the sheet would total $11,880.

Try this:

With
Values in A2:A10
Flags entered in B2:B10

This formula sums all flagged items
B11: =SUMIF(B2:B10,"?",A2:A10)

Note:
the wildcard ( ? ) allows you to use any single character at all to flag
values.

If you want to only sum on a specific flag, like "X", use this version
B11: =SUMIF(B2:B10,"x",A2:A10)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Tom" wrote:

$6,980 x
$11,880
$4,900 x

By putting an "X" in a cell adjacent to a number in a different cell is
there a way for a sheet to add up the cells chosen? Using the example above
the sheet would total $11,880.

Have look at SUMIF

=SUMIF(Q:Q,"x",P:P)

Regards

Trevor


"Tom" wrote in message
...
$6,980 x
$11,880
$4,900 x

By putting an "X" in a cell adjacent to a number in a different cell is
there a way for a sheet to add up the cells chosen? Using the example
above
the sheet would total $11,880.