count rows that match conditional formatting

[Carole]

I have a conditional format formula that looks for
duplicates.
=SUMPRODUCT(--($B$2:$B$961=$B2),--($D$2:$D$961=$D2),--
($E$2:$E$961=$E2))>1
When a duplicate is found, it changes the cell shading to
another color.

In another cell on the same spreadsheet, I want to get a
total count of the rows that have the shading changed.

What formula would I use to get the count?

 

[Frank Kabel]

Hi
if you don't need a one-cell formula put this formula in a separate
column, copy it for all rows and sum this column
=--(SUMPRODUCT(--($B$2:$B$961=$B2),--($D$2:$D$961=$D2),--($E$2:$E$961=$
E2))>1)

Afterwards you may hide this column