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?
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)