I thought I posted this Friday, but could not find it.

I have 46 columns, 3 colums per week of data (14 Weeks).

Week End 02/06/10
Total Jobs Completed Total Hours Worked Total Hours Per Unit
0 0.00 0.00
0 0.00 0.00
13 17.25 69.57
43 47.50 75.79
39 46.50 76.34
I need to average each 3rd column if more than 1. I've tried the following
but I get #value:
averageif(D6+G6+J6+M6+P6+S6+V6+Y6+AB6+AE6+AH6+AK6+ AN6+AQ6,"1",D6+G6+J6+M6+P6+S6+V6+Y6+AB6+AE6+AH6+A K6+AN6+AQ6)

I appreciate all the help I can get.

--
TC
Thanks