Adding Digits count.

[serge]

Hi everyone,

I have starting in columns BX7,BY7,BZ7 digits ranging from 0 to 3 (0,1,2,3 ) and I wanted to count each digits as they go down by rows in separated columns.

(0) starting in cell CB7
(1) starting in cell CD7
(2) staring in cell CF7
(3) staring in cell CH7

See example below :

[/URL][/IMG]


Thank you.
Serge.

 

[Fluff]

In CB7
=IF(COUNTIF($BX7:$BZ7,CB$5)=0,"",COUNTIF($BX$7:$BZ7,CB$5))

 

[rpaulson]

Fluff beat me to it.

 

[serge]

Thank you so much Fluff, that's exactly what I needed, Really appreciate the help.
Serge.

 

[Fluff]

You're welcome & thanks for the feedback