Find The Total And Maximum In A Date Range With Numbers (MacMost #1942)

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.

FOLLOW MACMOST FOR NEW TUTORIALS EVERY DAY
▶︎ YouTube — (And hit the 🔔)
▶︎ Weekly Email Newsletter — ✉️
▶︎ Twitter — and 🐦
▶︎ Facebook — 👍

SUPPORT MACMOST AT PATREON
▶︎ ❤️

#macmost #numbers #spreadsheets

Find The Total And Maximum In A Date Range With Numbers,maximum in range,numbers maximum,total in range,mac numbers,mac numbers date range,numbers,range,dates,test,total,sum,sumif,average,max,maximum,mac,macmost,