Please see below image.
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'.
Your help would be greatly appreciated to resolve this problem. It is by far too complex for my limited knowledge. Thanking you in advance.
Book1.jpg
Bookmarks