Posted to microsoft.public.excel.misc

AAS

external usenet poster

Posts: 24

averaging formula from three cells

i must make a formula to average a column of numbers but only the numbers
which are narrowed down from two other columns.

for example:

Production Calendar (sheet 1)

john doe Memco SMF $20
joe garcia SMH $13
jessie nelson Memco SMF $10
david toms Memco SMM $ 9

Wage Summary (sheet 2)

average wage of a Memco, SMF employee

The answer would be $15

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
averaging cells	Ravens Fan	Excel Discussion (Misc queries)	9	November 30th 07 05:53 PM
Averaging 14 Cells	Darren	Excel Discussion (Misc queries)	5	June 29th 06 09:52 PM
Averaging Cells Based On Conditions in Neighboring Cells	foofoo	Excel Discussion (Misc queries)	3	June 21st 06 03:10 AM
Averaging Cells	Daniel9684	Excel Discussion (Misc queries)	3	February 17th 06 07:21 PM
Averaging cells which contain #DIV/0!	maryj	Excel Worksheet Functions	4	November 4th 04 01:32 PM

All times are GMT +1. The time now is 04:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us