if isblank problem

T

tina

I have written following formula on technical sheet of my workbook
=if(isblank(q31:q36),0,sum(q31:q36)/4)
which gives me correct answer true version ie 0
but when try to enter on summary sheet as
=if(isblank(technical!q31:q36),0,sum(technical!q31:q36)/4)
i get false version
any ideas why?
Thanks Tina
 
V

Vaughan

On your summary sheet, do you have formulae in cells q31:q36? If so they aren't blank.

Also have you entered this as an array formula of the same size? Otherwise the results could be surprising.
 
Top