I have a drop down menu in d19:d30 with three options: TU, Local and Class. In E19:e30 I have revenue amounts. Not all rows may be used. In C35 I would like to have the total of revenue that came from Class. In d36 the total from Local and in D37 the total from TU. I am assuming I need an IF statement, but I'm not well versed in those. Any help is appreciated.
Bookmarks