Hello,
I have conditional formatting in column A and a count of those issues in column B. For instance, I would like to sum all fo the cells in column B in which the adjacent cell has conditional formatting (ie. if a cell in column A is red, I would like to sum all of cells adjacent to it in column B) Any recommendations?
I have conditional formatting in column A and a count of those issues in column B. For instance, I would like to sum all fo the cells in column B in which the adjacent cell has conditional formatting (ie. if a cell in column A is red, I would like to sum all of cells adjacent to it in column B) Any recommendations?