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



https://macmost.com/e-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 — http://macmost.com/j-youtube (And hit the 🔔)
▶︎ Weekly Email Newsletter — https://macmost.com/newsletter ✉️
▶︎ Twitter — https://twitter.com/rosenz and https://twitter.com/macmost 🐦
▶︎ Facebook — https://facebook.com/macmost 👍

SUPPORT MACMOST AT PATREON
▶︎ https://macmost.com/patreon ❤️

#macmost #numbers #spreadsheets

Youtube