I want to sum a part code if a different cell reference is I for example:
I J P Q (headings)
33114606 current 30
33114606 current 30
33114606 August 40
33114606 QOH 40

I want the return value to be 40 for if I
Then another formula that returns 60 for P where current
Then another formula that returns 40 for P where August
I have multible part codes in the list I want to do this to.