SUM a column but multiply if condition is met.

Column B has two options. Call or Admin. Column D is minutes. "CALL" minutes need to be multiplied by 2.

B3-Call D3- 5
B4-Admin D4-10

Time would be 20 minutes because D3's time is multiplied by 2 because B3 has "CALL" in it.

I would just add a helper column in Column E that says:

Formula:

Please Login or Register  to view this content.

Then you can just use =SUMPRODUCT for Columns D and E.

That appears to be PERFECT thank you!

can you help break down what you did there. I understand SUM IF condition B:B=Call then Sum D:D and multiple by 2, but does <> mean not equal? or anything other than?

"<>" is "not equal"

Thank you John.