Help with summing conditional formatted cells

[turan]

Hi,

I have conditionally formatted all cells in the range D2:BA1580 with the following conditional formula to highlight the cells yellow.

=NOT(OR(D2="A",D2="B",D2="C",D2="D", ISBLANK(D2)))

This has worked fine.

What I want to do now, is in the next column BB2 I want a formula that will count in those rows, the amount of times that a cell has been highlighted. Then copy this formula down to BB1580

I have read that sumproduct or dproduct might be able to do this, but when I tried it, it didn't work at all.

Any help would be great

 

[turan]

Ah don't worry I have worked my way around this and solved it