can't find a correct formula

[Jean-Paul De Winter]

Hi...
This is what I want

ItemA 6hours 6 8 9 6 7
ItemB 6hours 7 7 6 8 8
ItemC 6hours 7 8 6 6 8
ItemD 1 hour 5 8 6 7 8

First 3 items are 6 times as important then TemD

I have to calculate a %
This is my current formula: (SUM(D1:E8)*100/COUNT(D1:E8))/10
This formula however calculates all items as "heavy"
How should I solve this problem and....
What if all cells of ItemD are empty??? Then I devide by 0 and get an
errormessage.

Thanks

 

[Frank Kabel]

Hi
try
=IF(COUNT(B1:E8),AVERAGE(D1:E8)*10,"")

 

[Jean-Paul De Winter]

I also get an errormessage when cells are empty...
Also the formula I currently use wasn't correct... it should have been:

=(SUM(E6:I8)*6+SUM(E9:I9))*100/950
JP

 

[Frank Kabel]

Hi
my formula should return a blank cell if all cells are empty. what have
you tried exactly

Your formula should not return an error as you don't divide at all by
zero