SOLVED

Count Highlighted cells in another Sheet

Copper Contributor

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

2 Replies
best response confirmed by Blayke (Copper Contributor)
Solution

@Blayke 

=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!
1 best response

Accepted Solutions
best response confirmed by Blayke (Copper Contributor)
Solution

@Blayke 

=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))

 

View solution in original post