By selecting cells adjacent to cells tally sheet
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.
|