Posted to microsoft.public.excel.misc

Mike

external usenet poster

Posts: 3,101

Need Help on Average formula!!!

This is what i have
Z5:Z65=Different Names Of People
AA5:AA65=If (L) is entered =Laidoff
AE5:AE65= Hours worked for each name in cells Z5:Z65
In AB5:AB65 I want to Average hours of AE5:AE65 If an L is entered for each
name & hours in AA5:AA65 & If there is no L entered I need a zero value in
cells AB5:AB65

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
AVERAGE Formula Help	Steph	Excel Discussion (Misc queries)	2	May 16th 08 07:49 PM
Average formula	wannabe68	Excel Discussion (Misc queries)	4	April 13th 08 03:34 AM
A formula to AVERAGE IF but only average a set number of values	[email protected]	Excel Worksheet Functions	2	January 31st 08 08:28 PM
Average Row Formula	Tom	Excel Discussion (Misc queries)	2	May 7th 05 03:11 PM
how does one convert text to a formula "average(A:A)" to =average(	phshirk	Excel Worksheet Functions	4	April 14th 05 01:20 AM

All times are GMT +1. The time now is 03:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us