Posted to microsoft.public.excel.misc

neversummer neversummer is offline

external usenet poster

Posts: 4

average(if())

My data is in columns. I want to average those values that are 0<X1 only.
Tried using Average(if()) but am so far unsuccessful. Suggestions?

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
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce	TinaMo	Excel Worksheet Functions	7	April 23rd 08 05:19 PM
averageif	rudy	Excel Discussion (Misc queries)	5	April 27th 06 11:20 PM
how can i calc averageif	Bruce	Excel Worksheet Functions	3	June 18th 05 02:08 PM
"AverageIF" alternative	Flutie99	Excel Discussion (Misc queries)	2	May 27th 05 11:03 PM
AVERAGEIF Function out there?	davidad	Excel Discussion (Misc queries)	2	January 21st 05 05:52 PM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"