I have a table where I am counting SKUs in three separate columns from a CSV file. I also need a column that is the total number of SKUs from those three columns.
Column U , X, and Z are all counting correctly. However, the formula U:U + X:X + Z:Z is actually counting all the records. I'm not sure why the individual columns ignore blanks but the totaled column is counting blanks. If I filter out blanks on this column, all the of data in the rest of the columns disappear.
I've tried doing ARRAY with no luck