this sheet looks at the reference number and combines the total units together for the same product lines, i need the blank cells to be returned with a zero instead of being blank so the sheet will sum the counts correctly.
at the moment we filter all the blank cells and then add the zero in order to be able to sum the total picks.
i have highlighted blank cells in red.
|