If Statement + Is Number + CountA

[Datatellsall2]

Hello-

I have the following data set, which I'm trying to calculate the time spent based on =CountA of the items (columns A-E below).

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]Col. A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD]Item 1[/TD]
[TD]Item 2[/TD]
[TD]Item 3[/TD]
[TD]Item 4[/TD]
[TD]Item 5[/TD]
[TD]Total Time Spent (mins.)[/TD]
[TD]Time Spent - Item 1[/TD]
[TD]Time Spent - Item 2[/TD]
[TD]Time Spent - Item 3[/TD]
[/TR]
[TR]
[TD]100,000[/TD]
[TD]50,000[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]15[/TD]
[TD]7.5[/TD]
[TD]7.5[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

I'm trying to calculate columns G, H, and I. Column F time should be split evenly if there is values in columns A-E.

Right now my formula is =IF(A2=ISNUMBER(A2),F2/COUNTA($B2:$B26,0) but gives me the wrong output.

Really would appreciate any help where possible.

Thanks,
M

 

[jorismoerings]

Hi,

see if this helps:

Book1
	A	B	C	D	E	F	G	H	I
1	Item 1	Item 2	Item 3	Item 4	Item 5	Total Time Spent (mins.)	Time Spent - Item 1	Time Spent - Item 2	Time Spent - Item 3
2	100	50	0	0	0	15	7,5	7,5	0
Sheet1

Cell Formulas
Range	Formula
G2	=IF(A2>0,$F2/COUNTIF($A2:$E2,">0"),0)
H2	=IF(B2>0,$F2/COUNTIF($A2:$E2,">0"),0)
I2	=IF(C2>0,$F2/COUNTIF($A2:$E2,">0"),0)