LinkBack URL
About LinkBacks
Or maybe
=IFERROR(IF(COUNTBLANK(B6:B35)>29,"N/A",(SUMPRODUCT(--(ISNUMBER(MATCH('Jun 08'!$A$2:$A$731,$B$6:$B$35,0))),'Jun 08'!$B$2:$B$731)/(SUMPRODUCT(--(ISNUMBER(MATCH('Jun 08'!$A$2:$A$731,$B$6:$B$35,0))),'Jun 08'!$C$2:$C$731)*2))*100),"N/A")
Or maybe
=IFERROR(IF(COUNTBLANK(B6:B35)>29,"N/A",(SUMPRODUCT(--(ISNUMBER(MATCH('Jun 08'!$A$2:$A$731,$B$6:$B$35,0))),'Jun 08'!$B$2:$B$731)/(SUMPRODUCT(--(ISNUMBER(MATCH('Jun 08'!$A$2:$A$731,$B$6:$B$35,0))),'Jun 08'!$C$2:$C$731)*2))*100),"N/A")
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks