Dear Amar,
You can use SUMPRODUCT Function in 2003 instead of
countifs,Sumifs,Averageif and Averageifs.
On Tue, Aug 21, 2012 at 4:55 PM, amar takale wrote:
> Hi Vijayendra
> It is not excel 2003 version formula
>
> On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao
> wrote:
>
>>
>>
>> 2012/8/21
Hi Vijayendra
It is not excel 2003 version formula
On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao wrote:
>
>
> 2012/8/21 amar takale
>
>> Hi Vijayendra Rao
>> Can you send same sheet (If & Ifs) Bocs I used Excel 2003 so it is
>> difficult to understand. So Pls if possible Send me Sheet.
>> Than
Hi Vijayendra Rao
Can you send same sheet (If & Ifs) Bocs I used Excel 2003 so it is
difficult to understand. So Pls if possible Send me Sheet.
Thanks Very Much
Amar
On Thu, Aug 16, 2012 at 4:39 PM, Vijayendra Rao wrote:
>
> Hi,
>
> Please find attached file with example.
>
> Regards,
> Vijayendr
Hi All,
Please can you check and advise I have stopped receiving from group in my
inbox. Please can you advise whether my email Id is removed from
distribution list.
Thanks & Regards.
Amit Tiwari
On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> What is the correct use
It is quite simple
if you do not have the latest version of Excel you cannot use the functions
which were only introduced in that version. These include Sumifs,
averageifs, iferror. To get around the lack of Iferror you can use
=if(iseerror(formula),errorResult,formula)
On 18 August 2012 17:2
On Thu, Aug 16, 2012 at 6:15 PM, dguillett1 wrote:
> Homework?
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Kuldeep Singh
> *Sent:* Thursday, August 16, 2012 2:08 AM
> *To:* excel-macros@googlegroups.com
Homework?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Kuldeep Singh
Sent: Thursday, August 16, 2012 2:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ [█ ▆ ▅ ▃ ▂★AVERAGEIF & AVERAGEIFS★▂ ▃ ▅ ▆ █]
Hi Experts,
What is the correct
Hi,
Please find attached file with example.
Regards,
Vijayendra
2012/8/16 Amresh Maurya
> check below link. i hope it will help you.
>
>
> http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
>
>
> Reagrds
> Amresh
>
>
> On Thu, Aug 16, 2012 at 1:03 PM, amar t
check below link. i hope it will help you.
http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
Reagrds
Amresh
On Thu, Aug 16, 2012 at 1:03 PM, amar takale wrote:
> Hi Amresh,
> Can you give example file.I also not understand what is different between.
> Than
Hi Amresh,
Can you give example file.I also not understand what is different between.
Thanks for help
On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya wrote:
> Hi ,
>
> it works like sumif and sumifs..
>
> we used it for find average value with criteria
>
> [image: Inline image 1]
>
>
> Regards
>
Hi ,
it works like sumif and sumifs..
we used it for find average value with criteria
[image: Inline image 1]
Regards
Amresh
On Thu, Aug 16, 2012 at 12:38 PM, Kuldeep Singh wrote:
>
> Hi Experts,
>
> What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
> example with Excel Sh
Hi Experts,
What is the correct use of AVERAGEIF & AVERAGEIFS. Kindly share more
example with Excel Sheet.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (
12 matches
Mail list logo
