Excel 2007 : sum between two date with respect to specific customer

[shaileshgavanang]

Hi,

i am new to this group, i want help to solve my problem.
i made sales register in excel where i am adding my daily sales invoices.
i created one sample workbook.

i want total sales made to specific customer between two date.
i.e. sales made with customer abc ltd. between 01.01.2012 to 30.01.2012

please help

thank you,
Shailesh

[NBVC]

Assuming your start date in H2, and end date in H3, try:

=SUMIFS($E$5:$E$80,$B$5:$B$80,">="&H2,$B$5:$B$80,"<="&H3)

[shaileshgavanang]

hi,

thanks for the answer, but i want to find the sales made to particular customer, eg. sales made to abc ltd. between 01.01.12 to 31.01.2012

Assuming your start date in H2, and end date in H3, try:

=SUMIFS($E$5:$E$80,$B$5:$B$80,">="&H2,$B$5:$B$80,"<="&H3)

[NBVC]

You can add the condition to the formula.

Say the customer of interest is in H4, then formula is now:

=SUMIFS($E$5:$E$80,$B$5:$B$80,">="&H2,$B$5:$B$80,"<="&H3,$D$5:$D$80,H4)

[shaileshgavanang]

Thank you Sir, its working well,

thanks once again

You can add the condition to the formula.

Say the customer of interest is in H4, then formula is now:

=SUMIFS($E$5:$E$80,$B$5:$B$80,">="&H2,$B$5:$B$80,"<="&H3,$D$5:$D$80,H4)