Forum Discussion
How can I count cells with numbers?
Hi, I have a range of data that are formatted and wanted to know if there is a way to find the frequency/count for specific formatted ( by font or by fill color) cells along with the number inside t...
Hi John,
Perhaps you may use you conditional formatting rule formula
=SUMPRODUCT(--($A$1:$E$325=OFFSET($A$1:$E$325,1,0)))
to count cells under the rule and
=SUMPRODUCT(--($A$1:$E$325=OFFSET($A$1:$E$325,1,0))*(($A$1:$E$325=I3)))
for frequency
Hi Sergei,
The formula below worked great! Unfortunately, I cannot get it to work with a different conditionally formatted cells. I am now trying to find the frequency on numbers and cannot find a solution. Please see the excel attached. I will appreciate any help.