|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Code:
=IF(COUNTIF($I$2:I2,I2)=1,SUMIF($I$2:$I$433,I2,$H$2:$H$433),"0") |
#3
|
|||
|
|||
perfect thanks.
|
#4
|
||||
|
||||
@Kubi
The formula provided will return 0 as a text string, not as a number. ( which can sometimes cause problems) Removing the double quotes around the 0 will do the trick
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |