Posted to microsoft.public.excel.worksheet.functions

Noodnutt @ Work Noodnutt @ Work is offline

external usenet poster

Posts: 7

Average IF's

Hi Guy's

Can anyone help me out with the 2K version of the following plz.

=IF($C8=0,0,AVERAGEIF(Data!$AC$2:$AC$10000,"MAR-10",Data!L$2:L$10000))

This works great in 2007, but as with most things work related, they don't
have 2007 installed.

TIA
Mark.

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
Sum with 2 if's	Nadine	Excel Worksheet Functions	1	May 6th 10 10:08 PM
IF's	karensa	Excel Worksheet Functions	4	December 27th 06 10:05 PM
How many 'if's'?	Lynneth	Excel Discussion (Misc queries)	1	May 4th 06 03:59 PM
to many 'IF's'??	boufant	Excel Worksheet Functions	4	July 2nd 05 10:58 AM
How many if's?	Christopher Anderson	Excel Discussion (Misc queries)	4	January 5th 05 03:16 PM

All times are GMT +1. The time now is 08:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us