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

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

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
>
> 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
>

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" <(E-Mail Removed)> wrote
> in
> message news:(E-Mail Removed)...
> >
> > 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