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.

Comments Closed.