have a formula that combines two cells return a zero instead of a blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
have a formula that combines two cells return a zero instead of a blank cell

FAQ

Thread Tools

Display Modes

08-07-2017, 12:17 PM

Kubi

Windows XP have a formula that combines two cells return a zero instead of a blank cell

Office XP

Advanced Beginner

Join Date: May 2017

Posts: 34

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.

Attached Files

online test.xlsx (487.8 KB, 12 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
for visible cells (filtered), how find value lowest than 4.00 and return the cell number	murfy69	Excel	6	08-03-2017 12:03 AM
Random cell return using vlookup formula	mattbeaves	Excel Programming	3	05-22-2017 04:38 AM
Formula to return next non-blank cell in a range	Anyroad	Excel	4	09-15-2015 04:13 PM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM
Help with Subtotal(103, ) formula and blank cells	zhl203	Excel	1	07-30-2014 03:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 PM.