count of rows that match conditional formatting

[Carole]

I need to get a total count of the rows that match the
conditional formatting that was applied when it found
duplicates.

I used
=SUMPRODUCT(--($B$2:$B$961=$B2),--($D$2:$D$961=$D2),--
($E$2:$E$961=$E2))>1
to find each instance of duplicates.

 

[Bob Phillips]

Why have you added >1 on the end, that will force a True/False.

Try it without,

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Carole]

That is the string that identifies which rows to change
the cell shading as part of my conditional formatting.

I want to have a formula in another cell that gives me a
total count of those that are shaded.