|
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 |
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 |
| All times are GMT +1. The time now is 01:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com