Posted to microsoft.public.excel.misc

Posts: n/a

Average using lookup function

I have 3 seperate ranges and would like to have an average from 3
columns depending on whether or not a specific product has been entered
in the following cells.

B6:B19
B27:B40
H6:H19

If one of the above cells="My Product" then I would like an average of
the following ranges

C6:C19
C27:C40
I6:I19

Can anyone give me a simple formula

Pete

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 function question	Sum Limit and marking	Excel Worksheet Functions	4	July 8th 06 12:51 AM
Basing Average function range on Date?	DangerMouse	Excel Discussion (Misc queries)	4	June 20th 06 06:21 PM
average function	Sum Limit and marking	Excel Worksheet Functions	0	June 8th 06 04:49 PM
Calculate the average using the Lookup function or similar	Lars F	Excel Discussion (Misc queries)	2	November 22nd 05 11:40 AM
"Average" function query	Robin Blackwell	Excel Worksheet Functions	3	October 3rd 05 09:22 PM

All times are GMT +1. The time now is 09:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us