Put in R1: =COUNTIF($B$2:$Q$17,COLUMN(A1))
Copy across to S2

R1 gives the total of all the "1"s,
S2 gives the total of all the "2"s

Typos, sorry:

In the above, S2 should read as S1

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----