Hague2

Posts: n/a

Average

Column A1:A10 has a 0 or 1 in each cell, Column B1:B10 has numbers. I want
to be able to select the 0 (zero's) in Column A and AVERAGE only those
numbers at right in Column B.

I tried AVERAGE(IF(A1:A10=0,B1:B10) but got an average of all the numbers
in Column B, not just those at the right of 0.

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
Using The Average Function if a cell has NA	carl	Excel Worksheet Functions	6	May 21st 23 07:46 PM
average on 2 conditions	Ted Metro	Excel Worksheet Functions	6	January 7th 05 08:23 PM
Average	Reggie	Excel Worksheet Functions	2	December 29th 04 10:26 PM
calculate average hours worked	llstephens	Excel Worksheet Functions	1	November 24th 04 02:37 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 08:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us