SUMif with 2 conditional format

[oeyandyprawira]

Hi,

I'd like to have G2:G11 filled and sum automatically when met with more than 1 data that have the same condition as below,
G2 take value from E2 if A2=Housekeeping store and C2=Protekindo,PT
G3 take value from E3 if A3=stewarding store and C3=Ecolab Intl
G4 take value from E4 if A4=Laundry and c4=Protekindo
G5 take value from E5 if A5=General Store and D5=Guest supplies
G6 take value from E6 if A6=HOusekeeping store
G7 take value from E7 if A7=Laundry and D7=Guest supplies
G8 take value from E8 if A8=General Store and D8=Paper Supplies
G9 take value from E9 if A9=Housekeeping Store and D9=Paper supplies
G10 take value from E10 if A10=General Store and D10=Printing
G11 take value from E11 if A11=Housekeeping Store and D11=Printing

before
source.jpg

after
result.jpg

Regards,
Andy

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Describe your problem in the post itself (including the fromulas or code you're having troble with.