Excel Forum

Posted: **Wed Jun 29, 2016 7:47 am**

Dear
I have column A,B,C respectively
06-06-2016 16-06-2016 2137.50
16-06-2016 26-06-2016 2565
26-06-2016 06-07-2016 3420
06-07-2016 16-07-2016 997.50
07-07-2016 17-07-2016 897.75

I wanna calculate
checkin checkout
07-06-2016 17-06-2016 ?
17-06-2016 27-06-2016 ?
27-06-2016 07-07-2016 ?

please kindly elaborate

Regards,

Posted: **Wed Jun 29, 2016 9:49 am**

Please attach Excel example file.

Posted: **Wed Jun 29, 2016 6:18 pm**

Assuming that your data start on A1 onwards, cell E2 is 07-06-2016 and cell F2 is 17-06-2016

On G2 you can enter this formula.

=SUMIFS($C$2:$C$6,$A$2:$A$6,">="&E2,$B$2:$B$6,"<="&F2)

Enter

Posted: **Thu Jun 30, 2016 7:55 pm**

I try use sumproduct and sumifs but it is not working fine,please give me another solution,i message u by messenger the screenshot

Posted: **Thu Jun 30, 2016 8:52 pm**

Please attach Excel file and enter correct result.

Posted: **Fri Jul 01, 2016 9:09 am**

Could u give me mai id i shall forward it to and kindly upload in this group?

Posted: **Fri Jul 01, 2016 9:33 am**

Click the button in screenshort below, you can see attatchment in the bottom of comment box.

Excel Forum

cal

cal

Re: cal

Re: cal

Re: cal

Re: cal

Re: cal

Re: cal