Averaging data that meets a criteria
 

Hi all. I have a worksheet that has multiple entries. The entries
contain a month number (1 for jan, 2 for feb etc) in one column and
and a percentage in another. I'm trying to only average percentages in
january. Any idea how to do this? I couldn't get daverageto work.


--
Intuit
------------------------------------------------------------------------
Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=514543

Averaging data that meets a criteria
 

Intuit Wrote:
Hi all. I have a worksheet that has multiple entries. The entries
contain a month number (1 for jan, 2 for feb etc) in one column and
and a percentage in another. I'm trying to only average percentages in
january. Any idea how to do this? I couldn't get daverageto work.


I found this from another post, but I need the formulat to ignore cells
that state "divide by 0" or are blank.

=AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))


--
Intuit
------------------------------------------------------------------------
Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=514543

Averaging data that meets a criteria
 

Is this what you want

=AVERAGE(IF(($A$1:$A$200=C1)*($B$1:$B$200<0),$B$1 :$B$200))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Intuit" wrote in
message ...

Intuit Wrote:
Hi all. I have a worksheet that has multiple entries. The entries
contain a month number (1 for jan, 2 for feb etc) in one column and
and a percentage in another. I'm trying to only average percentages in
january. Any idea how to do this? I couldn't get daverageto work.


I found this from another post, but I need the formulat to ignore cells
that state "divide by 0" or are blank.

=AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))


--
Intuit
------------------------------------------------------------------------
Intuit's Profile:
http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=514543

Averaging data that meets a criteria
 

Enter as Ctrl/Shift/Enter

=AVERAGE(IF(($A$1:$A$200=$C$1)*(ISNUMBER($B$1:$B$2 00)),$B$1:$B$200))


Don Pistulka



"Intuit" wrote in
message ...

Intuit Wrote:
Hi all. I have a worksheet that has multiple entries. The entries
contain a month number (1 for jan, 2 for feb etc) in one column and
and a percentage in another. I'm trying to only average percentages in
january. Any idea how to do this? I couldn't get daverageto work.


I found this from another post, but I need the formulat to ignore cells
that state "divide by 0" or are blank.

=AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))


--
Intuit
------------------------------------------------------------------------
Intuit's Profile:
http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=514543

Averaging data that meets a criteria
 

Bob Phillips Wrote:
Is this what you want

=AVERAGE(IF(($A$1:$A$200=C1)*($B$1:$B$200<0),$B$1 :$B$200))

which is an array formula, it should be committed with
Ctrl-Shift-Enter, not
just Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Intuit" wrote
in
message ...

Intuit Wrote:
Hi all. I have a worksheet that has multiple entries. The
entries
contain a month number (1 for jan, 2 for feb etc) in one column
and
and a percentage in another. I'm trying to only average
percentages in
january. Any idea how to do this? I couldn't get daverageto
work.


I found this from another post, but I need the formulat to ignore
cells
that state "divide by 0" or are blank.

=AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))


--
Intuit

------------------------------------------------------------------------
Intuit's Profile:
http://www.excelforum.com/member.php...o&userid=30901
View this thread:
http://www.excelforum.com/showthread...hreadid=514543


That'll work, great thanks!!


--
Intuit
------------------------------------------------------------------------
Intuit's Profile: http://www.excelforum.com/member.php...o&userid=30901
View this thread: http://www.excelforum.com/showthread...hreadid=514543