Sum if date is between – Excel tips

In case sum is required if data in excel lies between two date SUMIFS can be used. SUMIFS is used add data which meet multiple conditions or criteria.

Use of SUMIFS to sum data between two dates

Here we have data for sale between 1 March to 6 March 2017. Now we need sum of sale after 2 March and before 5 March

Use of SUMIFS to sum data between two dates

 =SUMIFS(Data range ,date range,">"&B10,date range,"<"&B11)

Here we have used logical operator in double quotes. Whenever logical operator is to be used for criteria provide it in double quotes with ampersand (&) and cell reference else formula will result in error. For criteria we can use wild card (*,?), logical operator, text and number.

To download excel sheet click here