If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Average with Conditions
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 |
#2
|
|||
|
|||
Average with Conditions
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" .(do not spam) wrote in message ... 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 |
#3
|
|||
|
|||
Average with Conditions
=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 |
#4
|
|||
|
|||
Average with Conditions
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" .(do not spam) wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|