Hi
I have a Summary sheet, whereby I'm trying to keep an accurate stock update from my company store. I'm building this in a shared Google spreadsheet that I can share with my team.
I have managed to return the stock used for the first row of data, but although I think I'm referencing additional rows (down to 26), the formula isn't picking up the amounts from the next row. I've downloaded the document into regular Excel so I can attach it here, but that does seem to have the effect of breaking some stuff.....but please look at the screenshots attached.....can anyone see what I'm doing wrong, so that the formula doesn't recognise the 2nd row (and subsequent rows) of data?
Many thanks
Gemma
Bookmarks