Forum Discussion
Solved
Count Highlighted cells in another Sheet
Hello, I am trying to get a count of all the highlighted cells in each sheet to appear on the front sheet. The below is what I am struggling with, and I’ve attached an example of the data. I need to count to appear on the first sheet.
Count Highlighted cells in Column I Sheet ‘TE’ and have the sum of highlighted on sheet ‘MC’ Column F3
Count Highlighted cells in Column A Sheet ‘SYD’ and have the sum of highlighted on sheet ‘MC’ Column F4
Count Highlighted cells in Column B Sheet ‘Com’ and have the sum of highlighted on sheet ‘MC’ Column F5
=SUM(COUNTIFS(Com!B:B,TE!I2:I11)+COUNTIFS(SYD!A:A,TE!I2:I11)) =SUM(--(COUNTIF(TE!I:I,SYD!A2:A8)=0)) =SUM(--(COUNTIF(TE!I:I,Com!B2:B7)=0))
=SUM(COUNTIFS(Com!B:B,TE!I2:I11)+COUNTIFS(SYD!A:A,TE!I2:I11)) =SUM(--(COUNTIF(TE!I:I,SYD!A2:A8)=0)) =SUM(--(COUNTIF(TE!I:I,Com!B2:B7)=0))- Thanks heaps!
