No B2 isn't an empty cell, nor is E2. Both of those cells reference other cells in another tab therefore they have a formula in them. But I need to keep the formula. Your formula works perfectly if they were blank. The idea is the have the spreadsheet completely populate itself from the different tabs.