By selecting cells adjacent to cells tally sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

$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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select multiple adjacent cells of multiple cells without selecting 7
Formulas That Reference ADJACENT Sheet 4
Tally function assistance 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Adding A Date To Adjacent Cell 2
Adding data only if adjacent to cell labeled "male"/"female" 1
transpose array of non-adjacent cells 3
IF value in Y cell = X color Z cell 1

Back
Top