Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-07-2017, 12:17 PM
Kubi Kubi is offline have a formula that combines two cells return a zero instead of a blank cell Windows XP have a formula that combines two cells return a zero instead of a blank cell Office XP
Advanced Beginner
have a formula that combines two cells return a zero instead of a blank cell
 
Join Date: May 2017
Posts: 34
Kubi is on a distinguished road
Default


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
File Type: xlsx online test.xlsx (487.8 KB, 12 views)
Reply With Quote
 



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
have a formula that combines two cells return a zero instead of a blank cell Formula to return next non-blank cell in a range Anyroad Excel 4 09-15-2015 04:13 PM
have a formula that combines two cells return a zero instead of a blank cell 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft