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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im Newsbeitrag
...
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

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" schreef in bericht
...
Hi
try
=IF(COUNT(B1:E8),AVERAGE(D1:E8)*10,"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im Newsbeitrag
...
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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im Newsbeitrag
...
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" schreef in bericht
...
Hi
try
=IF(COUNT(B1:E8),AVERAGE(D1:E8)*10,"")

--
Regards
Frank Kabel
Frankfurt, Germany

"Jean-Paul De Winter" schrieb im
Newsbeitrag
...
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