Posted to microsoft.public.excel.misc

WildWill

external usenet poster

Posts: 64

AVERAGE IF with multiple conditions

I have 5 columns of data and need a a formula that will allow me to calculate
the following:

Average the values of column E for all instances where column A = "P1" and
column B = "Red" and Column D = "20". I.e. the average will only be
calculated for the lines in column E where the above conditions have been met
in the other columns, as mentioned.

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 with multiple conditions	WildWill	Excel Discussion (Misc queries)	1	February 10th 09 10:45 AM
Average of the last x entries with conditions	Gilbert DE CEULAER	Excel Worksheet Functions	3	September 28th 08 08:13 PM
Average with multiple conditions	Dez	Excel Worksheet Functions	4	July 11th 07 06:07 PM
AVERAGE with conditions	mr_concrete	Excel Worksheet Functions	3	February 7th 07 08:23 PM
average on 2 conditions	Ted Metro	Excel Worksheet Functions	6	January 7th 05 08:23 PM

All times are GMT +1. The time now is 08:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us