Prev: Oops
Next: How to set up a conditinal formula w/letters vs numbers?
From: Curtis on 9 Apr 2010 20:38
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
From: T. Valko on 9 Apr 2010 21:03
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" <curtis.eadie(a)yahoo.ca.(do not spam)> wrote in message
news:49FB0EFD-37E5-448B-A014-8EA5CE7D1ACD(a)microsoft.com...
>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


From: Teethless mama on 9 Apr 2010 21:39
=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
From: ozgrid.com on 9 Apr 2010 22:01
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" <curtis.eadie(a)yahoo.ca.(do not spam)> wrote in message
news:49FB0EFD-37E5-448B-A014-8EA5CE7D1ACD(a)microsoft.com...
>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

 | 
Pages: 1
Prev: Oops
Next: How to set up a conditinal formula w/letters vs numbers?