LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,101
Default desperately need help with average

This is what i have & works but need to do more
AO6:AO66 = Names from week 1 =IF(AW60,AW6,'Week 1'!S6)
AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6"",E6+AZ6,"")
AR6:AR66 =L means laidoff=IF(AY60,AY6,"")
AS6:AS66 = Average hours
{=IF(OR(AR6="L",AW6""),AVERAGE(IF(AT$6:AT$66=0,A T$6:AT$66)),"")}
AT6:AT66 = total hours of this week =IF(AR6="L","",AU6)
AU6:AU66 = Total hours of week 1 & this
week=IF(AR6="L",AS6,IF(B6="","",AQ6+SUM(F6:Q6)*1.5 +R6*2+S6*2))
AW6:AW66 = NAMES TO BE ADDED OR CHANGED
AY6:AY66 = L if name is laid off
AZ6:AZ66 = adjust hours if needed

What i need is to:
If AW6:AW66 "" this means names added or changed. Have average put in
AU6:AU66 some how added to what i used above for AU column
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Desperately need help [email protected] Excel Worksheet Functions 3 November 23rd 08 07:24 PM
Desperately in need of some help perfj New Users to Excel 2 April 8th 08 09:02 PM
DESPERATELY NEED HELP newuser Excel Discussion (Misc queries) 3 November 2nd 07 04:02 PM
Desperately need help!! Paula_p New Users to Excel 1 June 13th 06 10:26 PM
Desperately need help with 3 calculations Scoooter Excel Worksheet Functions 3 June 12th 06 04:28 PM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"