help me with gettin result with more than 2 criteria using index match or sumifs

[rahulsharma012]

Kindly send me the answer in k21 cell


http://www.fileconvoy.com/dfl.php?id=g62e965739ce772d19992922715770c42204f74517

 

[Faseeh]

Hi rahulsharma012,


Kindly try this SUMPRODUCT formula:

[pre]

=SUMPRODUCT(($C$2:$C$1080=$L$18)*($D$2:$D$1080=$N$18)*(A2:A1080>=L12)*(A2:A1080<=EOMONTH(L14,0))*($G$2:$G$1080))

[/pre]

Where L12 is 1-Jan-08 and L14 is 1-Mar-08 formatted as date.


Regards,

 

[rahulsharma012]

thanks a lot faseeh for a quick and obvious correct reply.

 

[Faseeh]

You are welcome Rahul.


Faseeh