AVERAGEIF FORMULA EXCEL 2007

[tcbooks]

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+AK6+AN6+AQ6)

I appreciate all the help I can get.

 

[JLatham]

Your first post is here, along with a couple of responses:
http://www.microsoft.com/office/com...e656&cid=a1178cfa-b744-427b-bfc6-24cbd450d79b