I have a dataset of over 20 columns and 1000 rows. I want to compute a formula that sums up the values in a column [in these context, Sales1 column, provided the values in the cell of Sales1 column and adjacent values of the cell in another column Sales2 are numeric.
Where a the cell in column Sales1 is numeric and the corresponding cell in column Sales2 is not numeric, check through the other rows of the sheet that has the same State name as the cell in question under the State Colum, if there exists at least one row on the sheet that has the same state name in the State column that has numeric values for both Sales1 column and Sales2 column, include the value of that cell in Sales1 column to compute the sum of Sales1 column.
Attached herewith is a subset of the dataset.
Thanks
Where a the cell in column Sales1 is numeric and the corresponding cell in column Sales2 is not numeric, check through the other rows of the sheet that has the same State name as the cell in question under the State Colum, if there exists at least one row on the sheet that has the same state name in the State column that has numeric values for both Sales1 column and Sales2 column, include the value of that cell in Sales1 column to compute the sum of Sales1 column.
Attached herewith is a subset of the dataset.
Thanks