I am trying the add numbers within certain date ranges that are from today’s date, and between 30 to 180 days in the past. For example, see below table
10 Feb, 2019 2
14 Jun, 2019 6
15 Oct, 2019 5
28 Nov, 2019 3
I want to add just the 5 and 6, and get 11 as my answer in my Summary Sheet Formulae cell.
What is the formula for doing this ?
Help Article Resources
Check out the Formula Handbook template!