Formula for columns

[Guest]

I have a Spreadhseet that I need to get some numbers on.

Example:

If I have a phrase in Column Q and want the amount in column O in the same
row to add with all of the other rows witht that same phrase. In Column Q
each row has "ER", "RE" or "IND" and I need the amount in column O that
corresponds with the Column Q to equal an amount in another box that I
create.

Is there a formula for that I can write for this?

Thanks

 

[Bernard Liengme]

=SUMIF(Q1:Q100,"ER",O1:O100)
OR
=SUMIF(Q1:Q100,A1,O1:O100) where Ai hold the value ER

OR experiment with the powerful Pivot Table feature
best wsihes

 

[Earl Kiosterud]

Vanessa,

For the first part, try this in some cell in row 2; =SUMIF(Q:Q,Q2,O:O)

For the second part, It isn't clear how you want "I need the amount in column O that
corresponds with the Column Q to equal an amount in another box that I
create" implemented.

 

[Guest]

Thank you so much! That helped me tremendously.

=SUMIF(Q1:Q100,"ER",O1:O100)
OR
=SUMIF(Q1:Q100,A1,O1:O100) where Ai hold the value ER

OR experiment with the powerful Pivot Table feature
best wsihes