Right now the issue I'm currently facing is I am trying to find a formula that will allow me to reference another page in my spread sheet. In my scenario the row I am referencing has 5 consectutive numbers after the reference point I would use for a vlookup. These numbers are all zeros except for one number in each row which will be a positive number greater than zero. I want my formula to check the first cell in the row, if it is not a zero it will show that number, but if this cell contains 0, then it moves over to the next cell. If all the cells in the row have a zero, then i just want zero to appear on my summary sheet. Any help would be appreciated. I tried to do a vlookup with an IF function, but I couldn't get it to work. I have attached a sample of what the spreadsheet looks like.Example doc.xlsx
Thanks,
Alex
Bookmarks