default_name
Board Regular
 Joined
 May 16, 2018
 Messages
 153
 Office Version

 2016
 Platform

 Windows
 MacOS
Hey guys,
I have looked online and have found some similar questions related to this, but nothing I have found seems to work.
I am trying to use a SUMIF statement on a large collection of data.
For the most part, it works just fine.
However, if there ever happens to be a blank cell in the [sum_range] variable then the entire formula gets botched, resulting in an #N/A
For reference:
Here is the formula I am currently working with:
So basically, if there happens to be a blank cell anywhere between L15:L20000 then the function throws an #N/A
How can I fix this so that blanks/empty cells are ignored. Is that even possible?
Thanks in advance
I have looked online and have found some similar questions related to this, but nothing I have found seems to work.
I am trying to use a SUMIF statement on a large collection of data.
For the most part, it works just fine.
However, if there ever happens to be a blank cell in the [sum_range] variable then the entire formula gets botched, resulting in an #N/A
For reference:
Code:
=SUMIF(range,criteria,[sum_range])
Here is the formula I am currently working with:
Excel Formula:
=SUMIF($I$15:$I$20000,$I9,L$15:L$20000)
So basically, if there happens to be a blank cell anywhere between L15:L20000 then the function throws an #N/A
How can I fix this so that blanks/empty cells are ignored. Is that even possible?
Thanks in advance
Last edited: