Is it possible to add percentage (%) amounts to a cell when another cell is changed?

[galls125]

Book1.xlsx

Please see attached example worksheet.

Is there a formula or do I need VBA to add the percentage amounts that appear in cells G4-G8 to cell D11 when the word 'COMPLETE' is selected in the corresponding line?

.i.e. / .e.g. when I select (from a drop down list) the word 'COMPLETE' in cell H5 the percentage amount in cell G5 gets added to cell D11.

There may need to be a formula in cell D11 because the value of D11 should change depending on how may cells in H4-H8 being selected as 'COMPLETE'.

IN SUMMATION: I need the percentage amount in G5 to be added to D11 when 'COMPLETED' is selected in H5. I also need the percentage amount in G6 to be added to D11 when 'COMPLETED' is selected in H6, etc - G7 add to D11 when H7 'COMPLETED' and G8 add to D11 when H8 'COMPLETED'.

Your help would be greatly appreciated to resolve this problem. It is by far too complex for my limited knowledge. Thanking you in advance.

[mmmarks]

Hi,

Look at attachment..

[galls125]

Thank you for taking the time to reply. Unfortunately the answer is not what I am looking for.

I need the percentage amount in G5 to be added to D11 when 'COMPLETED' is selected in H5.

I also need the percentage amount in G6 to be added to D11 when 'COMPLETED' is selected in H6, etc - G7 add to D11 when H7 'COMPLETED' and G8 add to D11 when H8 'COMPLETED'.

[Fotis1991]

Hi

Pls, upload a sample workbook(not a picture) and if you like, answer to us in the questions that i made to you in your other thread...

[mmmarks]

Thank you for taking the time to reply. Unfortunately the answer is not what I am looking for.

I need the percentage amount in G5 to be added to D11 when 'COMPLETED' is selected in H5.

I also need the percentage amount in G6 to be added to D11 when 'COMPLETED' is selected in H6, etc - G7 add to D11 when H7 'COMPLETED' and G8 add to D11 when H8 'COMPLETED'.

Yes. Upload the sample file so that You can get accurate and desire result.

[galls125]

Hi

Pls, upload a sample workbook(not a picture) and if you like, answer to us in the questions that i made to you in your other thread...

Thanks. I've worked out how to attach a file. Please see attached.

Book1.xlsx

[Fotis1991]

Hi

So,try this.

=SUMPRODUCT((H4:H8="COMPLETE")*(E4:E8))+SUMPRODUCT((H4:H8="COMPLETE")*(G4:G8*E4:E8))

Is this, what are you looking for?

[galls125]

Thank you for your reply.

Almost.

I input the formula into D11 and it equalled $111,800 when it should equal $130,000.

I need D11 to add the values in column E (E4, E5, E6, E7, E8) when the word 'COMPLETE' is selected in the corresponding line in column H (H4, H5, H6, H7, H8) .i.e.

when 'COMPLETE' is selected in cell H4 the value in cell E4 is added to D11,
and when 'COMPLETE' is selected in cell H5 the value in cell E5 is added to D11,
and when 'COMPLETE' is selected in cell H6 the value in cell E6 is added to D11,
and when 'COMPLETE' is selected in cell H7 the value in cell E7 is added to D11,
and when 'COMPLETE' is selected in cell H8 the value in cell E8 is added to D11.

Thanks again for looking at this.

[Ignesh]

The best & simple way is to have the PIVOT TABLE set and when ever there is a change, one refresh on pivot will have you amounts refreshed and ready to use.

[Fotis1991]

I am sure that we can find your solution, if i understand how you think!

In the sample i show you with yellow color which are the conditions that i use.

Can you do the same and highlight the conditions that YOU need to add??