Thread
:
Calculation of weighed average
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
jkrons
external usenet poster
Posts: 19
Calculation of weighed average
Sorry for the trouble. It just came to me :-(
SUM(D3:K3)*2/(COUNT(D3:K3)*2+COUNTBLANK(D3:K3))
Jan
Reply With Quote
jkrons
View Public Profile
Find all posts by jkrons