Hi all -
I have a formula which I recently had to change and now when some of the fields aren't filled it is giving me a #VALUE error. I suspect that is because in some cases it is trying to divide by nothing because a user hasn't added that value in there.
Can someone help me integrate an additional (ISERROR) function into the formula I have below so that if there is an error it will just leave the cell blank? I just can't seem to get it right. Obviously the field it is dividing by is in column K
=IF(ISBLANK(I4),"",SUMIFS(Rest,Date,">="&C4,Date,"<="&D4,Product,E4,Adcoop,H4,DC,I4))/K4
I have a formula which I recently had to change and now when some of the fields aren't filled it is giving me a #VALUE error. I suspect that is because in some cases it is trying to divide by nothing because a user hasn't added that value in there.
Can someone help me integrate an additional (ISERROR) function into the formula I have below so that if there is an error it will just leave the cell blank? I just can't seem to get it right. Obviously the field it is dividing by is in column K
=IF(ISBLANK(I4),"",SUMIFS(Rest,Date,">="&C4,Date,"<="&D4,Product,E4,Adcoop,H4,DC,I4))/K4