I have a table with columns for YEAR, CATEGORY (food, beverage, rental, misc, av, service charge), STATUS (actual, forecast, OTB), RMNOTB (a #) and REVENUE $. I also have a named range for BUDGET YEAR (budget_year).
I need a formula to add the revenue amounts then divide by # of RMN OTB IF...