By selecting cells adjacent to cells tally sheet
$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. |
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. |
By selecting cells adjacent to cells tally sheet
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. |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com