Originally Posted by daddylonglegs 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
View Tag Cloud
Forum Rules
Bookmarks