If Statment using Criteria

[Guest]

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,

 

[Guest]

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.

 

[Guest]

Magnificent. Thanks.

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.

 

[Ragdyer]

You can carry this a step further by assigning a cell to hold the ID number.
That way, you can simply key in various ID numbers to return their
corresponding totals.

=SUMIF(A1:A7,C1,B1:B7)

Where you can enter the ID number in C1, and not have to change the formula
itself to return the totals for a different ID.