PC Review


Reply
Thread Tools Rate Thread

Average with Conditions

 
 
Curtis
Guest
Posts: n/a
 
      10th Apr 2010
I need to a formula that will look at column c and if it contains a certain
text say "dog" I want to average the price located in column H

Thanks
--
ce
 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      10th Apr 2010
Try one of these...

Excel 2007 or later:

=AVERAGEIF(C2:C10,"dog",H2:H10)

Any version of Excel:

=SUMIF(C2:C10,"dog",H2:H10)/COUNTIF(C2:C10,"dog")

This one is array entered:

=AVERAGE(IF(C2:C10="dog",H2:H10))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Curtis" <(E-Mail Removed).(do not spam)> wrote in message
news:49FB0EFD-37E5-448B-A014-(E-Mail Removed)...
>I need to a formula that will look at column c and if it contains a certain
> text say "dog" I want to average the price located in column H
>
> Thanks
> --
> ce



 
Reply With Quote
 
Teethless mama
Guest
Posts: n/a
 
      10th Apr 2010
=AVERAGE(IF(C2:C100="dog",H2:H100))

ctrl+shift+enter, not just enter


"Curtis" wrote:

> I need to a formula that will look at column c and if it contains a certain
> text say "dog" I want to average the price located in column H
>
> Thanks
> --
> ce

 
Reply With Quote
 
ozgrid.com
Guest
Posts: n/a
 
      10th Apr 2010
I would avoid array formulas and simply use;
=SUMIF(C1:C100,"dog",H1:H100)/COUNTIF(C1:C100,"dog")


--
Regards
Dave Hawley
www.ozgrid.com

"Curtis" <(E-Mail Removed).(do not spam)> wrote in message
news:49FB0EFD-37E5-448B-A014-(E-Mail Removed)...
>I need to a formula that will look at column c and if it contains a certain
> text say "dog" I want to average the price located in column H
>
> Thanks
> --
> ce


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average with Conditions Curtis Microsoft Excel Worksheet Functions 1 13th May 2010 04:34 PM
Average with Conditions Curtis Microsoft Excel Worksheet Functions 3 18th Mar 2010 05:31 PM
average with 2 conditions =?Utf-8?B?cw==?= Microsoft Excel Programming 6 15th Mar 2006 01:51 PM
average with conditions vinnie123 Microsoft Excel Programming 3 15th Mar 2006 10:26 AM
average on 2 conditions =?Utf-8?B?VGVkIE1ldHJv?= Microsoft Excel Worksheet Functions 6 7th Jan 2005 08:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:20 AM.