Hi all, I'm trying to sum four cells in second row (K2, L2, M2 & N2).
Cell K2 worth 4 times, L3 worth 3 times, M2 worth 2 times, N2 worth 1 time.
Then use SumIf depend on what text is in the target cell (H2).
"High" value is multiply by 3, "Medium" multiply by 2, "Low" multiply by 1.
Only half way through formula is working.
This is the formula I'm using below and have attached sample.
=((K2*4)+(L2*3)+(M2*2)+(N2*1))*(SUMIF(H2,"High",L17)+SUMIF(H2,"Medium",L18)+SUMIF(H2,"Low",L19))
Thanks in advance.
Bookmarks