Average If Questions

[Fireguy2014]

Hi. I am trying to calculate averages for some Team Members production rates for each shift on a weekly basis. The problem I am having is that there are some shifts where they are in other functions and therefore have 0 production quantities. I want to remove any value of 0 from my averages. I only want to calculate shifts where they have been in production.

For example:

Last Name	First name	User Name	Badge #	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Weekly	Average
Smith	Gerry			860	0	952	757	1005	0	3574	854.50
Brand	Kimberly			700	655	825	693	987	0	3860	835.00

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Thank you very much in advance for any suggestions.

Fireguy

 

[JoeMo]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Last Name	First name	User Name	Badge #	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Weekly	Average
2	Smith	Gerry			860	0	952	757	1005	0	3574	893.5
3	Brand	Kimberly			700	655	825	693	987	0	3860	772
Sheet2

 

[Fireguy2014]

Thank you very much Joe.

 

[JoeMo]

Thank you very much Joe.

You are welcome - thanks for the reply.