I have two sheets that are the same except for the sheet names, in one
column on both sheets B8:B107 can contain multiple duplicates. i have a
column that uses this code to count how many duplicates of each record.
=""& COUNTIF($B$8:B8,B8)
What formula do i need to add that will count the duplicates that occur on
sheet one and sheet two.

Also on another note using this code is there some reason why i can't
conditional format those cells and a zero value appears. i do have it to not
show zero values as it hides other calculated cells on these sheets.

Many Thanks in Advance
Greg