Dear Sunil,
Please use..
For 2007+
=AVERAGEIF(F1:F10,">0")
For 2003
=SUMPRODUCT((F1:F10>0)*(F1:F10))/COUNTIF(F1:F10,"<>0")
On Thu, Feb 9, 2012 at 4:49 PM, sunil bn wrote:
> Hi Expert,
>
>
>
> Please find the attached file.
>
>
>
> 1. I need “average formula” which includes 0 value.
>
> --
Thank u maries
Regards
Sunil B.N
®Sent From Android Mobile©
On 9 Feb 2012 17:02, "Maries" wrote:
> Hi,
>
> Find the below formulas,
>
> =SUM(F1:F10)/COUNTIF(F1:F10,">0")
>
> =SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0))
>
> =SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0")
>
> =SUM(F1:F10)/(SUMPROD
Also Try,
*=AVERAGEIF(F1:F10,">0")
*
On Thu, Feb 9, 2012 at 3:33 PM, Lakshman Prasad wrote:
> Sorry,
>
> =AVERAGE(F2:F11)
>
> *From:* sunil bn
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, 9 February 2012 4:49 PM
> *Subject:* $$Excel-Macr
Sorry,
=AVERAGE(F2:F11)
From: sunil bn
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1. I need “average formula” which
Hi,
Find the below formulas,
=SUM(F1:F10)/COUNTIF(F1:F10,">0")
=SUM(F1:F10) / (COUNT(F1:F10) - COUNTIF(F1:F10,0))
=SUMIF(F1:F10,">0")/COUNTIF(F1:F10,">0")
=SUM(F1:F10)/(SUMPRODUCT((F1:F10<>0)*1))
Regards,
MARIES.
On Thu, Feb 9, 2012 at 3:19 PM, sunil bn wrote:
> need “average formula” whi
Hello Mr. Sunil
Use =AVERAGE(F2:F11,{1})
From: sunil bn
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 4:49 PM
Subject: $$Excel-Macros$$ excel macros - Sunil B.N
Hi Expert,
Please find the attached file.
1. I need
Hi Expert,
Please find the attached file.
1. I need “average formula” which includes 0 value.
--
*Regards*
**Sunil B.N
***
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Fo
