Dear All,
Do we have any option for countifs & Sumifs formula in MS Excel 2003?
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003
Dear All,
Do we have any option for countifs & Sumifs formula in MS Ex
mifs formula in MS Excel
2003
=sumproduct((a2:a22=1)*b2:b22)
From: Amit Desai (MERU)<mailto:amit.de...@merucabs.com>
Sent: Tuesday, August 30, 2011 11:24 AM
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: $$Excel-Macros$$ Option for countifs & Sumifs form
=sumproduct((a2:a22=1)*(b2:b22))
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
What about option for countifS?
Best Regards,
Amit Desai
From: e
tion for countifs & Sumifs formula in MS Excel
2003
=sumproduct((a2:a22=1)*(b2:b22))
From: Amit Desai (MERU)<mailto:amit.de...@merucabs.com>
Sent: Tuesday, August 30, 2011 12:03 PM
To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>
Subject: RE: $$Excel-Macros$$
6
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
But what if I need a count (& not sum)of numbers in a cell?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro
TRY it!!!
From: Amit Desai (MERU)
Sent: Tuesday, August 30, 2011 12:18 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
But what if I need a count (& not sum)of numbers in a cell?
Best Regards,
Amit Desai
Hi Amit
See below link for Sumifs in 2003
http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003
--
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU)
wrote:
> Dear All,
>
> ** **
>
> Do we have any option for countifs & Sumifs formula in M
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Wednesday, August 31, 2011 7:33 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS
Excel 2003
Hi
excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
> *Sent:* Wednesday, August 31, 2011 7:33 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS
> Excel 2003
>
> ** **
>
> Hi Amit
>
>
Of Rajan_Verma
Sent: Wednesday, August 31, 2011 11:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
See the attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Venka
Have you tried looking at the help index for countifs?
From: Amit Desai (MERU)
Sent: Friday, September 02, 2011 4:51 AM
To: excel-macros@googlegroups.com
Subject: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
Dear Rajan,
Thanks for this..but I do want to
ros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Rajan_Verma
Sent: Wednesday, August 31, 2011 11:04 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
See the attached
From: excel-macros@google
: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel
2003
Dear All,
Continuing from my below issue… my assistant have 2003 version of excel & I
have 2007. I need to pass on the task of preparing this MIS. But the same was
prepared with countifs (2007 function).
Need your
2 count ifs)
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma
> *Sent:* Wednesday, August 31, 2011 11:04 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$ Option for count
15 matches
Mail list logo