Hello,
I have the following formula copied down 300 rows, when it encounters the first empty row, it returns a 0 instead of the expected blank. this is the only time this occurs over 300 rows.
This is causing me issues in other sheets that refer to these cells.
=IF(COUNTIF($A$2:A5,A5)=1,SUMIF($A$2:$A$30,A5,$B$2:$B$30),"")
I've attached a small sample sheet to illustrate the problem.
Bookmarks