Adding text to equal no value and skip over to do average

[Ckoy909]

I have a table for the month with dates on one row, amount of calls reviewed per day on second row(row2), hours Worked on the third row(row3) and each column has a fourth row which. does an average of Row2/Row3. at the end of row2 and row3 it sum the totals. on certain days my reps have PTO and i want to insert the word "PTO" in tow row3 and take any value from the colum so it only adds the rows with data...

 

[Robert Mika]

I have a table for the month with dates on one row, amount of calls reviewed per day on second row(row2), hours Worked on the third row(row3) and each column has a fourth row which. does an average of Row2/Row3. at the end of row2 and row3 it sum the totals. on certain days my reps have PTO and i want to insert the word "PTO" in tow row3 and take any value from the colum so it only adds the rows with data...

Hello and welcome to MrExcel.
Could you post your data,please?
Please see below in my signature how to do it.

 

[Ckoy909]

Hello and welcome to MrExcel.
Could you post your data,please?
Please see below in my signature how to do it.

this is an example of the spreedsheet to track productivity only thing different is that it would be from the 1st of the month to the last day in this case the 31st. I would appreciate it if i can get the formula to calculate this along with inputing "PTO" on days off and making that section not have a value or count it as part of averages. thank you ahead of time
[TABLE="class: grid, width: 100, align: center"]
<TBODY>[TR]
[TD]JANUARY's
Tracker[/TD]
[TD]01/01/13[/TD]
[TD]01/02/13 [/TD]
[TD]01/03/13[/TD]
[TD]01/04/13[/TD]
[TD]totals[/TD]
[TD]Monthly Average[/TD]
[/TR]
[TR]
[TD]calls[/TD]
[TD]18[/TD]
[TD]22[/TD]
[TD]30[/TD]
[TD]PTO[/TD]
[TD]70 calls[/TD]
[TD]23.3[/TD]
[/TR]
[TR]
[TD]hours[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]24 hours[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]average call pr hour[/TD]
[TD]2.25[/TD]
[TD]2.75[/TD]
[TD]3.75[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2.91[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[Robert Mika]

this is an example of the spreedsheet to track productivity only thing different is that it would be from the 1st of the month to the last day in this case the 31st. I would appreciate it if i can get the formula to calculate this along with inputing "PTO" on days off and making that section not have a value or count it as part of averages. thank you ahead of time
[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]JANUARY's
Tracker[/TD]
[TD]01/01/13[/TD]
[TD]01/02/13[/TD]
[TD]01/03/13[/TD]
[TD]01/04/13[/TD]
[TD]totals[/TD]
[TD]Monthly Average[/TD]
[/TR]
[TR]
[TD]calls[/TD]
[TD]18[/TD]
[TD]22[/TD]
[TD]30[/TD]
[TD]PTO[/TD]
[TD]70 calls[/TD]
[TD]23.3[/TD]
[/TR]
[TR]
[TD]hours[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]0[/TD]
[TD]24 hours[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]average call pr hour[/TD]
[TD]2.25[/TD]
[TD]2.75[/TD]
[TD]3.75[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]2.91[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Not 100% sure about your request but
Try this:

Excel 2010
	A	B	C	D	E	F	G
1	JANUARY's	1/1/2013	1/2/2013	1/3/2013	1/4/2013	totals	Monthly Average
2	Tracker
3	calls	18	22	30	PTO	70 calls	23.33
4	hours	8	8	8	0	24 hours
5	average call pr hour	2.25	2.75	3.75	0		2.92
Sheet1

Cell Formulas
Range	Formula
G3	=AVERAGE(B3:E3)
G5	{=AVERAGE(IF(B5:E5>0,B5:E5))}
E5	=IF(E3="PTO",0,E3/E4)
Press CTRL+SHIFT+ENTER to enter array formulas.