Averaging data that meets a criteria

[Intuit]

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]

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))

 

[Bob Phillips]

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)

 

[Don]

Enter as Ctrl/Shift/Enter

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


Don Pistulka

 

[Intuit]

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)

in
message news:[email protected]...

That'll work, great thanks!!