Posted to microsoft.public.excel.worksheet.functions

Connie Martin Connie Martin is offline

external usenet poster

Posts: 251

Difficult Average Function

I am stumped. How in the world do I write this formula?

In a cell, I want it to find the date in A9 in A42:A5000 and then average
the numbers in J42:J5000 for that date. Hope this is clear. Many thanks in
advance.
Connie

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
Difficult function	Teacher in Revetal	Excel Worksheet Functions	12	February 10th 07 10:56 AM
Difficult Average Calculation <HELP	jk	Excel Worksheet Functions	4	July 6th 06 06:32 PM
Difficult IF Function (For me at least) help	pete321	Excel Worksheet Functions	1	June 15th 06 02:59 AM
Difficult function: help needed.	Beertje	Excel Discussion (Misc queries)	14	October 19th 05 11:24 AM
Error Handling #N/A with AVERAGE Function - Average of values in Row	Sam via OfficeKB.com	Excel Worksheet Functions	13	July 31st 05 03:59 PM

All times are GMT +1. The time now is 02:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us