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.