If/count?? Function

[cruch9]

I need help on how to do a function. Not even sure what function to use. I am trying to keep track of production percents per shift. I get daily production percents from each operator daily. I am going to enter either 1, 2 or 3 for what shift they were on and the %. On a seperate sheet I want to have it average all 1st shift in one cell and so on with 2nd and 3rd. Hope someone can help. Thanks

 

[VoG]

Perhaps like this

Excel Workbook
	A	B	C
1	Shift	%	Avg 1
2	2	45	53.66667
3	1	59
4	3	71
5	3	70
6	3	80
7	3	21
8	1	68
9	2	38
10	3	72
11	1	62
12	1	66
13	3	78
14	3	32
15	2	62
16	2	46
17	1	25
18	2	38
19	1	42
20	3	72
21	3	53
Sheet2

 

[cruch9]

I have each employee on a different sheet. so there are several sheets.

 

[cruch9]

i tried this but it doesnt work:

=AVERAGE(IF(sheet1:sheet20!B6:B36)=1,(sheet1:sheet20!D6:H36))

 

[cruch9]

any ideas? thanks

 

[cruch9]

any ideas?

 

[j_latendre]

Try this:

=IF((SUM(Sheet1:Sheet20!B6:B36)/COUNT(Sheet1:Sheet20!B6:B36))=1,(Sum(Sheet1:Sheet20!D6:H36)/count(Sheet1:Sheet20!D6:H36)),"")

Make sure Sheet1 and Sheet20 are spelt exactly like that and not like sheet1 and sheet20. Punctuation matters.

Jesse