Something Like - SUMIF

[RetroMe]

Hi All,

I am trying to find a formula that will add the total costs of customers purchases between two given dates.

I have a list of 10,000 transactions from about 150 customers.

I used a SUMIF to calculate the total spending of customers but I cannot get the total costs between two dates.

Hope I have provided enough info for someone to be able to assist.

Thanks in advance.

Alex

 

[barry houdini]

Which version of Excel do you have? In Excel 2007 or later versions you can use SUMIFS function (with an "S" on the end), i.e.

=SUMIFS(Values,Dates,">="&Date1,Dates,"<="&Date2)

or in earlier versions

=SUMPRODUCT(Values,(Dates>=Date1)*(Dates<=Date2))

 

[RetroMe]

Thanks Barry.

I am using 2010. Your formula works perfectly!