Hello, I am in need of a formula that will add up certain date ranges. With every project that is virtually supported, our potential cost savings is $2200. Now, going off of the "Arrival Date" column, I want to add up the projects virtually supported based on quarters of the month. What SUMIFS formula would I use to…
Instead of having to manually input $2200, can I input a formula that when a check box is checked it automatically inputs the $2200 value?