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 Sergie,
I want to count any numbers that are in a given row (e.g., 28,39,20,34,14) that recycle into the next above row (e.g., 7,17,28,34,8) and to be able to plot the frequency of occurrence:
Numbers: Freq:
28 1
34 1
7 0
17 0
Hi John,
I changed conditional formatting rule formula on
=COUNTIF(OFFSET(A2,-1,1-COLUMN(A2),,5),A2)
which applied starting from row #2, and the formula to calculate frequency
=SUMPRODUCT(--(MMULT(--($A$2:$E$325=$I3)+--(OFFSET($A$2:$E$325,-1,0)=$I3),{1;1;1;1;1})>1))