xrayr

Posts: n/a

DAverage Function help needed

I have a spreadsheet with columns of data on sheet 1. I would like to have
the average of column "U" determined ONLY when the corresponding data in
Column "C" equals a certain value (date value shown as: "2005/01/01")

I would like this average shown on another sheet that I have termed "Summary".

I cannot get this to work.

Somebody please help!

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
Excel option to store trendline's coefficients in cells for use	Miguel Saldana	Charts and Charting in Excel	9	June 20th 05 08:45 PM
weeknum function says jan1=week1, mod to first 4 day week needed	sam	Excel Discussion (Misc queries)	3	June 13th 05 04:05 PM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM

All times are GMT +1. The time now is 11:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us