Google Sheets Database Reporting: Multiple Criteria

It turns out there are severe limitations to the google sheet filter formula if you have a fairly complex list of data points about something and you want to test that something against multiple things before the logic decides to pull that given row into a summary report.

Template for Marketing Spend Return on Investment - Recurring Revenue

When I first thought about the difficulties of this calculation, I realized it is probably something nearly any recurring revenue business model struggles to figure out accurately. The problem is figuring out the ROI (return on investment) of the money you spend in a given month on sales/marketing as it relates to the future revenue directly related to that spend.