$$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Amit Desai (MERU)
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread dguillett1
=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

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Amit Desai (MERU)
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread dguillett1
=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

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Amit Desai (MERU)
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$$

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Kiran Kancherla
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread dguillett1
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Venkat CV
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

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-08-30 Thread Venkat CV
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 > >

FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread Amit Desai (MERU)
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread dguillett1
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

RE: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread Amit Desai (MERU)
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

Re: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-05 Thread dguillett1
: $$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

Re: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread NOORAIN ANSARI
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