Posted to microsoft.public.excel.worksheet.functions

Dez

external usenet poster

Posts: 10

Average with multiple conditions

Hi how do i take the avearage of numbers in one column, with conditions being
satisfied in two other different colums?

this is what i've tried but it's just not working;

AVERAGE(IF(AND($B$2:$B$1931="2000"),$C$2:$C$1931=" 1",$D$2:$D$1931))

could someone please help. thanks!

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 with conditions	mr_concrete	Excel Worksheet Functions	3	February 7th 07 08:23 PM
Conditional Average (2 conditions)	kayard	Excel Worksheet Functions	3	August 12th 06 12:32 AM
Using AVERAGE with conditions in different worksheets?	mommy2kh	Excel Worksheet Functions	1	July 16th 06 11:16 PM
How to multiple conditions to validate more than 2 conditions to .	Bhuvana Govind	Excel Worksheet Functions	1	January 28th 05 07:07 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 09:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us