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).

Col. A	B	C	D	E	F	G	H	I
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
100,000	50,000	0	0	0	15	7.5	7.5	0

<tbody>
</tbody>

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)