Formula Help

[JPSWEET]

I have a sheet I created and mind you I am no expert wehre I have personell listed in a calendar type sheet in the left colums I have names and the top corresponds with the date there are certain duties that need to be performed and I have a number key for each duty so if on one day they have missed 3 duties I wil put 1,2,3, etc. I need the end of the row to specify how many times each of those duties has not been performed by adding them up individually by number with 1 for duty a in 1 coulum 2 for the second duty and so on.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=COUNTIF($B$2:$N$2,COLUMN(A1))
& drag right. change the range to suit.