Dear Dileep and Ravindra
Very very Thanks for solution
Regards
Shrinivas
On Thu, Feb 13, 2014 at 10:44 AM, Ravinder wrote:
> =SUMIFS(B2:B22,A2:A22,">="&D6,A2:A22,"<="&E6)
>
>
>
> OR
>
> PFA
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sh
=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: $$Excel-Macros$$ Help on sumif function
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
