Existing formula but need to add an additional site from another sheet

Question

I need help with an existing formula on a spreadsheet. I added another site, school 4 (sheet 3), to an existing dropdown menu on sheet 1. When I then start using school 4 from the dropdown menu on sheet 1, the data from sheet 2 isn't automatically filling in; how do I get this to calculate it to 1.5

Here are some screen shots; thanks!

dscheikey · Answer

mfgutierrez2003&nbsp;The reason is because your formula points to row 4 and column 5. The cell is empty.&nbsp;

mfgutierrez2003 · Answer

Thank you; I needed to add those areas to the formula on Sheet 1, but didn't know how to do that for school 4. The formula from sheet 1 only exports data from Sheet 2 for Campus 1, 2 and 3. I just couldn't figure out how to recalculate and update formula on Sheet one for all the cell.

Forum Discussion

Existing formula but need to add an additional site from another sheet

Share

Resources