Project Revenue by geographic location, filtering out some projects by name (SUMIFS?)
I’m working on a spreadsheet and would love help on a formula. (SUMIFS?) The first tab tracks all my projects completed by row, and columns include project name, revenue, and location. The next tab I’d like rows by geographic location, and columns to include location, total revenue, and revenue from all project types except 2. I’m using an excel similar to the attached, and would like to see revenue by state, without including revenue from Fairs or Festivals. Any help is appreciated!
Tab 1:
Tab 2:
I’m working on a spreadsheet and would love help on a formula. (SUMIFS?) The first tab tracks all my projects completed by row, and columns include project name, revenue, and location. The next tab I’d like rows by geographic location, and columns to include location, total revenue, and revenue from all project types except 2. I’m using an excel similar to the attached, and would like to see revenue by state, without including revenue from Fairs or Festivals. Any help is appreciated!Tab 1: Tab 2: Read More