Brent,

The easiest way to accomplish this would be to use the "SumIf" function. If
you have your IDs in cells A1 thru A7 and your data in cells B1 thru B7 then:

SumIf(A1:A7, "ID#", B1:B7)

Hope that helps.

"Brent E" wrote:

Good afternoon,

I am trying to assist somebody at work. I would like to ask if there is a
way to set a formula in a totals cell at the bottom or a spreadsheet (for
example) where for every cell in
Column A that contains a certain ID, their corresponding values in column B
are summed. For instance if A2 A3 AND A11 contain a specific ID, then a
'totals' cell would add B2, B3 AND B11. I would like to use an IF statement
or something for example: (SUM B cells where A cells=ID). What syntax would I
use for this? Thanks.

Cordially,