Twodogs

If all you want is a simple count of how many columns from A-H contain 1,2 or 3, the formula I sent before will work. Are you after a count or a sum/total?
After using ctrl+shift enter the formula will appear like this....
****=SUM(IF(A1:H1>0,IF(A1:H1<=3,1,0),0))****

Soho