Add sales between two dates without using sum or sumproduct function

Shweta

Well-known Member
Joined
Jun 5, 2011
Messages
514
Hi All,

Please help me out on the below query

DateSales
1/7/2011500
2/7/2011600
3/7/2011700
4/7/2011800
5/7/2011900
6/7/20111000
7/7/20111100
8/7/20111200
9/7/20111300

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

Who is Mr Spreadsheet?
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

<thead>
</thead><tbody>
</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)

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top