Is there an AVERAGE IF function in Excel?

BradHaberman BradHaberman is offline

Junior Member

Location: Washington

Posts: 2

Quote:

Originally Posted by eliwaite

I trying to average one row if another row's value is true. I know there is a
sumif, and a countif, but couldn not find an averageif. If you could let me
know who to do this, that would be wonderful.

Thank you,
Eli

How about
IF(*row is true*, average(array), *row not true*)

Where *row is true* is the row being checked and *row not true* is what is expected if false ie,. "" for a null string.

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 a Timestamp function that does not update in Excel?	Guard 823	Excel Worksheet Functions	2	February 25th 05 02:42 PM
Return value with using Excel function	SNOWBALLCHAN	New Users to Excel	1	February 21st 05 07:25 AM
The description of the ATAN2 function in Microsoft Excel is not 1.	Celeste	Excel Worksheet Functions	2	February 18th 05 03:00 PM
Access Module coded converted to Excel Function	Adam	Excel Discussion (Misc queries)	1	December 23rd 04 02:48 PM
I cant use englisch function names in a swedich version of excel	PE	Excel Discussion (Misc queries)	2	December 7th 04 01:00 AM

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

Menu

About Us