Howard

Posts: n/a

Average If

I need a formula that works for =AVERAGEIF(A4:A50,0,B4:B50) I want to be able
to average one row of cells if the corsponding row shows a certen value.
If A4:A50 has a 0 in it add the corsponding cells in B4:B50 it to the cell
that the formula is in and average it by the number of cells that had numbers
were taken out of.

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 06:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us