Re: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Shrinivas Shevde
egroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde > *Sent:* Thursday, February 13, 2014 9:28 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Help on sumif function > > > > > Dear All, > > > > Please find

RE: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Ravinder
=SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6) OR PFA From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: Thursday, February 13, 2014 9:28 AM To: excel-macros@googlegroups.com Subject: $$Exc

Re: $$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Dileep Kumar
Dear Shrinivas, Use sumifs for summing ranges based on more than one criteria, sumifs will handile number of criterias for summing ranges. Same like countifs also. If your are summing ranges which are located in othere workbooks better to use sumproduct rather usning sumifs, coz sumifs will not w

$$Excel-Macros$$ Help on sumif function

2014-02-12 Thread Shrinivas Shevde
Dear All, Please find attached sheet -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thre