Quote Originally Posted by daddylonglegs View Post
You can't use AND, use this syntax
=AVERAGE(IF(A2:A6=1;IF(C2:G6<>"";C2:G6)))
confirmed with CTRL+SHIFT+ENTER
that's it! thanks a lot!