View Single Post
 
Old 08-04-2015, 07:05 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

What your formula is doing is counting the number of blanks in the row in Table2 corresponding to the row in Table1. If the the data in the first columns of either table differ at all, you will not get the correct result.

The simplest solution would be to combine the tables. I understand your sample is likely a very simple example of your actual tables so it might be cumbersome. But as it is, both tables appear to have the same primary key i.e. the testees' names and thus theoretically would work.

There's certainly a way to do it the way you have it set up now, but I can't think of it. I'll ponder it.
Reply With Quote