# Add sales between two dates without using sum or sumproduct function

#### Shweta

##### Well-known Member
Hi All,

 Date Sales 1/7/2011 500 2/7/2011 600 3/7/2011 700 4/7/2011 800 5/7/2011 900 6/7/2011 1000 7/7/2011 1100 8/7/2011 1200 9/7/2011 1300 I was given the above table in an interview and was asked to find the sum between two dates without using sum and sumproduct. I know the answer with sum and sumproduct function. But dont know any other solution Please provide me an appropriate formula for this if it is possible without using sum or sumproduct function Thanks in advance! Regards, Shweta

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Hi Shweta,

That's an odd interview question, but perhaps SUMIF or SUMIFS (Excel 2007+), like this:

Sheet1
ABCDEF
1DateSalesDate 1Date 2Sum
201/07/201150003/07/201108/07/20115700
302/07/20116005700
403/07/2011700
504/07/2011800
605/07/2011900
706/07/20111000
807/07/20111100
908/07/20111200
1009/07/20111300

</tbody>
Excel 2010

Worksheet Formulas
CellFormula
F2=SUMIF(A2:A10,">="&D2,B2:B10)-SUMIF(A2:A10,">"&E2,B2:B10)
F3=SUMIFS(B2:B10,A2:A10,">="&D2,A2:A10,"<="&E2)

</tbody>

<tbody>
</tbody>

I was thinking the same. Because Sumproduct is the favourite function of all the Excel users.

Thanks for the help! It's working perfectly.

Regards,
Shweta

Replies
6
Views
385
Replies
3
Views
919
Replies
31
Views
818
Replies
3
Views
406
Replies
2
Views
695

1,211,452
Messages
6,101,936
Members
447,764
Latest member
gopalgriffith

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back