Renee

Posts: n/a

Average If Question

We are trying to average the numbers in one column only if they equal any
or all of 6 different numbers from a different column (7474, 7921, 8612,
9011, 3945, 2209).

We are using this formula, but it seems to be giving us slightly different
numbers than if we just pulled the numbers together through sorting and took
the average.
=AVERAGE(IF(B1:B9={7474, 7921, 8612, 9011, 3945, 2209},C1:C9,FALSE))

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
Average If Question	Renee	Excel Discussion (Misc queries)	6	March 29th 05 09:39 PM
complex count question	JBoulton	Excel Worksheet Functions	13	March 24th 05 02:57 AM
Average the Last Five Cells in a Column	Warrior Princess	Excel Worksheet Functions	3	March 16th 05 02:12 PM
OFFSET function question	Joseph Spain	Excel Worksheet Functions	11	February 1st 05 07:01 PM
average, array and offsets	Darin1979	Excel Worksheet Functions	0	November 17th 04 04:21 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us