software

I know how to calculate the Average within a range of cells - however,
what I would like to do is calculate the average but for only those
cells that return a figure based on the results of another formula -
example:if you have 6 cells but only 3 cells return a value, I would
like the average calculated on the 3 cells and not based on 6 - and
similarly, if another 2 figures are entered, the formula then
calculates the average of the 5 figures - hope this makes sense.--
martins
------------------------------------------------------------------------
martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=526065You could use a combination formula to get your average..........

=SUMIF(A1:A10,quot;gt;0quot;)/COUNTIF(A1:a10,quot;gt;0)

Adjust the ranges as needed........

Vaya con Dios,
Chuck, CABGx3
quot;martinsquot; wrote:

gt;
gt; I know how to calculate the Average within a range of cells - however,
gt; what I would like to do is calculate the average but for only those
gt; cells that return a figure based on the results of another formula -
gt; example:if you have 6 cells but only 3 cells return a value, I would
gt; like the average calculated on the 3 cells and not based on 6 - and
gt; similarly, if another 2 figures are entered, the formula then
gt; calculates the average of the 5 figures - hope this makes sense.
gt;
gt;
gt; --
gt; martins
gt; ------------------------------------------------------------------------
gt; martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
gt; View this thread: www.excelforum.com/showthread...hreadid=526065
gt;
gt;


Yep - does the trick - was also wondering how you would allow for a
minus figure within the list of cells to add, as occasionally this does
happen ---
martins
------------------------------------------------------------------------
martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=526065=SUMIF(A1:A10,quot;lt;gt;0quot;)/COUNTIF(A1:A10,quot;lt;gt;0quot;)

Vaya con Dios,
Chuck, CABGx3
quot;martinsquot; wrote:

gt;
gt; Yep - does the trick - was also wondering how you would allow for a
gt; minus figure within the list of cells to add, as occasionally this does
gt; happen -
gt;
gt;
gt; --
gt; martins
gt; ------------------------------------------------------------------------
gt; martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
gt; View this thread: www.excelforum.com/showthread...hreadid=526065
gt;
gt;

Then again, SUMMING zero does noting, while COUNTING does so
=SUM(A1:A10)/COUNTIF(A1:A10,quot;lt;gt;0quot;)
best wishes from a pedantic me!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;CLRquot; gt; wrote in message
...
gt; =SUMIF(A1:A10,quot;lt;gt;0quot;)/COUNTIF(A1:A10,quot;lt;gt;0quot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;martinsquot; wrote:
gt;
gt;gt;
gt;gt; Yep - does the trick - was also wondering how you would allow for a
gt;gt; minus figure within the list of cells to add, as occasionally this does
gt;gt; happen -
gt;gt;
gt;gt;
gt;gt; --
gt;gt; martins
gt;gt; ------------------------------------------------------------------------
gt;gt; martins's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=31616
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=526065
gt;gt;
gt;gt;

To introduce another scenario - if I added another column which then
gave a total based on different calulation, how would you configure the
count formula as advised here - to count only the column which returned
a result?--
martins
------------------------------------------------------------------------
martins's Profile: www.excelforum.com/member.php...oamp;userid=31616
View this thread: www.excelforum.com/showthread...hreadid=526065