simora
07-26-2021, 03:29 PM
How can you use a WorkSheet SumIF formula to sum cells on another worksheet based on Cell.Interior.ColorIndex
I need to sum all cells in another worksheet specific Column H with a Cell.Interior.ColorIndex=17
The formula is NOT on the worksheet with the data.
I need to sum all cells in another worksheet specific Column H with a Cell.Interior.ColorIndex=17
The formula is NOT on the worksheet with the data.