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:49FB0EFD37E5448BA0148EA5CE7D1ACD(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:49FB0EFD37E5448BA0148EA5CE7D1ACD(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? 