Google Sheets Database Reporting: Multiple Criteria

There are severe limitations to the Google Sheet filter formula. For example, if you have a database composed of many columns it will be difficult to filter with multiple criteria and logic.

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.