Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGEIF FORMULA EXCEL 2007
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AVERAGEIF FORMULA EXCEL 2007
Your first post is here, along with a couple of responses:
http://www.microsoft.com/office/comm...6-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+A K6+AN6+AQ6) I appreciate all the help I can get. -- TC Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - AVERAGEIF on rows that are non-continuous | Excel Worksheet Functions | |||
Is there an AVERAGEIF function in excel? | Excel Discussion (Misc queries) | |||
Help with Averageif Formula (don't think I should use Averageif) | Excel Discussion (Misc queries) | |||
Excel AverageIF issue... PLEASE HELP! | Excel Worksheet Functions | |||
AVERAGEIF equivalent in excel 2000 | Excel Discussion (Misc queries) |