=SUMIF Formula update help

[zone709]

Hi so i use this formula on my sheet =SUMIF(AM$2:AM$200,AO2,H$2:H$200) Formula in Column AP

AO is the names where the formula is matching the names in AM to total things up. What i want to do is. Use the same formula but pull in the names in column AO. They are different names every time and have to update the name list in AO. Trying to avoid this and pick up the names and total it up thanks.

 

[Sufiyan97]

Hi

Still not getting what you are trying to achieve.

Does this work?

=SUMIF(AO$2:AO$200,AO2,H$2:H$200)

 

[zone709]

I enter the names i need to look at to sum up in column AO. I rather it pick up the names in AM that are only there put them into AO and sum up the same way in AP. So i don't have to update the name list in AO all the time. So if i drag the formula down in AP for totals i want it to also drag the names down in AO so i don't have to add the names all the time.