Calculating values for the given year without using the helper cells.

[thilag]

Hello Friends


Attached file : <Yearwise.xlsx>
Version : MS Excel 2010

I want to populate the yellow cells by formula.

thanks

thilag

[samba_ravi]

E2=SUMPRODUCT((YEAR($A$1:$A$72)=$D2)*1)
F2=SUMPRODUCT((YEAR($A$1:$A$72)=$D2)*($B$1:$B$72))
G2=F2/E2
Copy towards down

[thilag]

Hello Siva

Perfect solution,

thanks

thilag