Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread NOORAIN ANSARI
Hi Samitha, Please find attached sheet with *DSUM & SUMPRODUCT.* - Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 29, 2011 at 2:53 PM, smitha.ku

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread Aivi
*** > > Smitha > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Aivi > *Sent:* Tuesday, November 29, 2011 3:24 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Mac

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread smitha.kumari
: Tuesday, November 29, 2011 2:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria An easy solution would be Sumif Function. See attached. Regards, Manish On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari wrote

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread Aivi
2:55 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Formula to sum a range of cells > satisfying a particular criteria > > ** ** > > An easy solution would be Sumif Function. See attached. > > > > > > Reg

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread smitha
Thanks Manish From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Manish Pandey Sent: Tuesday, November 29, 2011 2:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria An

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread Manish Pandey
An easy solution would be Sumif Function. See attached. Regards, Manish On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari wrote: > Hi, > > ** ** > > PFA the expense sheet and suggest a formula to solve the problem as > mentioned in the attachment. > > ** ** > > Regards > > Smitha