if isblank problem

[Guest]

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

 

[Frank Kabel]

Hi
try
=if(countblank(technical!q31:q36)=6,0,sum(technical!q31:q36)/4)

 

[Guest]

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.