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
DATE NUMBER
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 ?