Add sales between two dates without using sum or sumproduct function

[Shweta]

Hi All,

Please help me out on the below query

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>

 

[circledchicken]

Hi Shweta,

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

Sheet1

	A	B	C	D	E	F
1	Date	Sales		Date 1	Date 2	Sum
2	01/07/2011	500		03/07/2011	08/07/2011	5700
3	02/07/2011	600				5700
4	03/07/2011	700
5	04/07/2011	800
6	05/07/2011	900
7	06/07/2011	1000
8	07/07/2011	1100
9	08/07/2011	1200
10	09/07/2011	1300

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

Excel 2010

Worksheet Formulas Cell Formula 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>

 

[Shweta]

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

 

[circledchicken]

Your welcome!