# Find The Total And Maximum In A Date Range With Numbers

It is fairly easy to use a SUMIF function to find a total for rows that meet a condition. But there is no easy way to get the total for rows inside a range of dates. By using extra hidden columns, you can easily mark rows depending on whether they are in a date range, and then use SUMIF to get the total. Getting the maximum value in that range is a little trickier, but can be done with an additional column and the MAX function.

### Comments: 2 Responses to “Find The Total And Maximum In A Date Range With Numbers”

Craig Miller
5 years ago

Hi Gary,
I really enjoy the shows, keep up the good work!
Thanks for the tip to calculate the average and max values, very helpful.

To sum values in a date range (without the true/false column), I use the SUMIFS function, enclose the >= and =â€œ&

The formula in cell C3 would look like:
SUMIFS(Sales,Date,">="&Date Range Results::\$B\$1,Date,"<="&Date Range Results::\$B\$2)

Hope this helps
Regards Craig

5 years ago

Craig: Right. But the point is you can't get the maximum that way.