Excel – Run formula only If cell contains a value

microsoft excel

I'm using Microsoft Office 365. I'd like to do something like

=(SUM(J4:J20)+K23)/G23

but sometimes K23 doesn't have a value. So I'm thinking I need to say only do +K23 if it contains a value.

How would I do that?

Best Answer

Try using

=SUM(J4:J20,IF(K23<>"",K23))/G23

Unless sometimes G23 is blank or zero, replace /G23 with /if(G23<>"",G23,1)

Related Question