I'm running into an issue and looking for some input. In the attached file, on sheet 'MICHIGAN 2020', in columns T and V, I'm pulling data from another sheet ('PLAYER ALL STATS TOP TEAM'). What I'm trying to do is pull the data from the data sheet into 'MICHIGAN 2020' column T. That new data will be added to the total in the row just above to give a new total. The numbers should increase as you move down each row. The issue is, that a few of the data points are a "0", and I'd like for the cell to sit empty if that's the case. Also, I'd like for the row below the empty cell, to skip that empty cell and continue the adding process. Instead I'm getting the ### or #VALUE! errors. I've tried to figure out a formula with IFERROR included, but I'm not having success.
I'm sorry if this explanation isn't helpful. You can see the attached file. I'd ask you to look at sheet 'MICHIGAN 2020', cells T6:V8, as this successfully shows what I'd like to do, without a zero occurrence. Cells T9:V11 show the issue I'm running into with a 0 as the data in the source cell on the data sheet.
Thank you for any assistance you can give.
Bookmarks