query relating to sumif formula

[Attique]

I want to get customer wise sales total value between two dates give below

For example find attachment

Requirment
Start Date 15-Sep-15
End Date 15-Dec-15
Amount of Sale to each customer between these two dates ?



"I have tried sumifs formula but was not able to get the required result.
Can Someone help me out?"

[NeedForExcel]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Khalidngo]

Hi Attique,

Try this in requirement sheet:
=SUMIFS(Before!$I$2:$I$23,Before!$A$2:$A$23,B2,Before!$C$2:$C$23,">="&B3,Before!$C$2:$C$23,"<="&B4)

Where:
B2 = 14797
B3 = 15/09/2015
B4 = 15/12/2015

Result would be: 259.88

Blessing

[Attique]

Thanks for you reply khalid bhai....but it did not work it gives zero answer

[sandy666]

=SUMIFS(Before!$I$2:$I$23,Before!$A$2:$A$23,14797,Before!$C$2:$C$23,">=15-Sep-15",Before!$C$2:$C$23,"<=15-Dec-15")

=SUMIFS(Before!$I$2:$I$23,Before!$A$2:$A$23,14894,Before!$C$2:$C$23,">=15-Sep-15",Before!$C$2:$C$23,"<=15-Dec-15")

you can change >= and <= to > and < if 15-Sep-15 and 15-Dec-15 are out of range

with custom format #,##0_);-#,##0 you will get 260 and 58

also you can use formula from #3 but format for cells B3 and B4 is dd-mmm-yy so you will get 15-Sep-15 and 15-Dec-15 not 15/09/2015
It shouldn't be B3 and B4 but e.g. K1 and K2 because B3 and B4 are in Issue# range. Format the same as above.