|re: "I am trying to total the number dates in in Column O based on the SUMPRODUCT from the previous 3 table arrays."|
I'm not sure what you mean by "trying to total the number dates".
Are you trying to have the SUMPRODUCT only return a count of ABC, NORTH, TABLE if there is also a date in Column O?
As written, your formula will first calculate the number of rows where ABC, NORTH, TABLE are all present and then subtract the number of cells in Column O that contain any value. There is no relationship between the SUMPRODUCT part of your formula and the COUNT part. They are really 2 independent calculations.
What exactly are you trying to calculate?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.