code for changing #DIV/0! error to "NULL"

[reinerhgarcia]

Hi to all,

I had a problem regarding these code:
(SUMIFS('Raw Data - Storage'!$K$2:$K$100000,'Raw Data - Storage'!$K$2:$K$100000,">=1800",'Raw Data - Storage'!$D$2:$D$100000,"Weather",'Raw Data - Storage'!$B$2:$B$100000,"MS*")/($D$7)/60)

Whenever I use this code, if there is no value in column K that is greater than or equal to 1800, it shows a #DIV/0! errors. Can someone help me how to change this to #DIV/0! = NULL instead?

I need some advise on this.

Thanks guys!

 

[Aladin Akyurek]

Hi to all,

I had a problem regarding these code:
(SUMIFS('Raw Data - Storage'!$K$2:$K$100000,'Raw Data - Storage'!$K$2:$K$100000,">=1800",'Raw Data - Storage'!$D$2:$D$100000,"Weather",'Raw Data - Storage'!$B$2:$B$100000,"MS*")/($D$7)/60)

Whenever I use this code, if there is no value in column K that is greater than or equal to 1800, it shows a #DIV/0! errors. Can someone help me how to change this to #DIV/0! = NULL instead?

I need some advise on this.

Thanks guys!

Try one of...

=IF($D$7,(SUMIFS('Raw Data - Storage'!$K$2:$K$100000,'Raw Data - Storage'!$K$2:$K$100000,">=1800",'Raw Data - Storage'!$D$2:$D$100000,"Weather",'Raw Data - Storage'!$B$2:$B$100000,"MS*")/($D$7)/60),0)

=IF(N($D$7),(SUMIFS('Raw Data - Storage'!$K$2:$K$100000,'Raw Data - Storage'!$K$2:$K$100000,">=1800",'Raw Data - Storage'!$D$2:$D$100000,"Weather",'Raw Data - Storage'!$B$2:$B$100000,"MS*")/($D$7)/60),0)

 

[reinerhgarcia]

Wow! that works ! ^^

Thank you very much for your reply!

Cheers!

 

[Aladin Akyurek]

Wow! that works ! ^^

Thank you very much for your reply!

Cheers!

You are welcome. Thanks for providing feedback.