software

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: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=514543
Intuit Wrote:
gt; Hi all. I have a worksheet that has multiple entries. The entries
gt; contain a month number (1 for jan, 2 for feb etc) in one column and
gt; and a percentage in another. I'm trying to only average percentages in
gt; 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 quot;divide by 0quot; or are blank.

=AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))--
Intuit
------------------------------------------------------------------------
Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=514543Is this what you want

=AVERAGE(IF(($A$1:$A$200=C1)*($B$1:$B$200lt;gt;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)

quot;Intuitquot; gt; wrote in
message ...
gt;
gt; Intuit Wrote:
gt; gt; Hi all. I have a worksheet that has multiple entries. The entries
gt; gt; contain a month number (1 for jan, 2 for feb etc) in one column and
gt; gt; and a percentage in another. I'm trying to only average percentages in
gt; gt; january. Any idea how to do this? I couldn't get daverageto work.
gt;
gt;
gt; I found this from another post, but I need the formulat to ignore cells
gt; that state quot;divide by 0quot; or are blank.
gt;
gt; =AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))
gt;
gt;
gt; --
gt; Intuit
gt; ------------------------------------------------------------------------
gt; Intuit's Profile:
www.excelforum.com/member.php...oamp;userid=30901
gt; View this thread: www.excelforum.com/showthread...hreadid=514543
gt;
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
quot;Intuitquot; gt; wrote in
message ...
gt;
gt; Intuit Wrote:
gt;gt; Hi all. I have a worksheet that has multiple entries. The entries
gt;gt; contain a month number (1 for jan, 2 for feb etc) in one column and
gt;gt; and a percentage in another. I'm trying to only average percentages in
gt;gt; january. Any idea how to do this? I couldn't get daverageto work.
gt;
gt;
gt; I found this from another post, but I need the formulat to ignore cells
gt; that state quot;divide by 0quot; or are blank.
gt;
gt; =AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))
gt;
gt;
gt; --
gt; Intuit
gt; ------------------------------------------------------------------------
gt; Intuit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30901
gt; View this thread: www.excelforum.com/showthread...hreadid=514543
gt;

Bob Phillips Wrote:
gt; Is this what you want
gt;
gt; =AVERAGE(IF(($A$1:$A$200=C1)*($B$1:$B$200lt;gt;0),$B$1 :$B$200))
gt;
gt; which is an array formula, it should be committed with
gt; Ctrl-Shift-Enter, not
gt; just Enter.
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Intuitquot; gt; wrote
gt; in
gt; message ...
gt; gt;
gt; gt; Intuit Wrote:
gt; gt; gt; Hi all. I have a worksheet that has multiple entries. The
gt; entries
gt; gt; gt; contain a month number (1 for jan, 2 for feb etc) in one column
gt; and
gt; gt; gt; and a percentage in another. I'm trying to only average
gt; percentages in
gt; gt; gt; january. Any idea how to do this? I couldn't get daverageto
gt; work.
gt; gt;
gt; gt;
gt; gt; I found this from another post, but I need the formulat to ignore
gt; cells
gt; gt; that state quot;divide by 0quot; or are blank.
gt; gt;
gt; gt; =AVERAGE(IF($A$1:$A$200=C1,$B$1:$B$200))
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Intuit
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Intuit's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30901
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=514543
gt; gt;

That'll work, great thanks!!--
Intuit
------------------------------------------------------------------------
Intuit's Profile: www.excelforum.com/member.php...oamp;userid=30901
View this thread: www.excelforum.com/showthread...hreadid=514543