VBA Create A matrix of data from tables

Hi Can someone help,
I need to create a table that has counts of "NULL" based on the data from another tables, please see a example of what i want to achieve below.
Problem is the data is continuous so there will a lot more of U and D numbers but they follow similar patter.


Matrix.jpg

The Table produced should be on another sheet, but for convenience i have added it on one sheet. The data starts at cell G7 sometimes there may be "NULL" on say E12, i would NOT want those nulls counted, just the "NULL" on Cell G7 and on wards..Example.xlsx

Please read the advice on the yellow banner?

Just one thing ive noticed, when there are one null value for one u and d, it does not count the nulls, example below..


U1 U2
D1 Null Null

D2 Null Null

I know it been a long time but need some help with this topic again when it is D1 and U1 Group only i get a type mismatch error any ideas?

Please Login or Register  to view this content.