Formula for columns

V

Vanessa

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
 
B

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
 
V

Vanessa

Thank you so much! That helped me tremendously.

Bernard Liengme said:
=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
Click to expand...
 
Top