Prev: Data Validation
Next: Show Pivot Table Dates in a Month/Year Linear Fashion
From: tcbooks on 12 Apr 2010 14:38
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.

--
TC
Thanks
From: JLatham on 12 Apr 2010 15:03
Your first post is here, along with a couple of responses:
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.worksheet.functions&mid=c8db9062-ea68-4c37-888c-5c4708bbe656&cid=a1178cfa-b744-427b-bfc6-24cbd450d79b


"tcbooks" wrote:

> 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.
>
> --
> TC
> Thanks
 | 
Pages: 1
Prev: Data Validation
Next: Show Pivot Table Dates in a Month/Year Linear Fashion