Posted to microsoft.public.excel.worksheet.functions

Tasha

external usenet poster

Posts: 157

Dynamic average

I will get this sheet done if it kills me!!! My sheet is set up as follows:

Col A: doctor names
Columns D-AH: daily numbers
Row 2:dates 1-31

In cell AK2, I am trying to find the average of columns D-AH for each row,
for the current date. There are 0's filled in the fields that are greater
than today. I think I've given enough information, if not....please ask!!!

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
Dynamic Rolling Average	Lancer940	Excel Worksheet Functions	5	January 19th 07 08:15 PM
Average Function and dynamic cell address	spartanmba	Excel Worksheet Functions	2	September 30th 06 09:24 PM
Dynamic annual average	[email protected]	Charts and Charting in Excel	4	July 31st 06 11:49 PM
Dynamic Average Question	Greg	Excel Discussion (Misc queries)	2	July 5th 06 09:44 PM
Dynamic Average	Big H	Excel Worksheet Functions	4	November 5th 05 09:34 PM

All times are GMT +1. The time now is 12:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us