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
=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
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
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