% of Actual achievement / progress formula

[Ihab]

Hi All,

I need some help with the excel sheet attached.

how can I find a formula to show the actual % of achievement up to date.

plese find attached.

regards,
Ihab

 

[Anant Chirmade]

Hi Ihab,

If you are talking about achiement in days, then you can use below formula :

=SUMPRODUCT(I10:I15,K10:K15)/SUM(I10:I15)

 

[Ihab]

thanks really Anant, I tried it in my excel sheet attached but didn't know how. can you please help me in doing it on my excel sheet and i will study what you did. appreciate it.

regards,