I have a contractors that provide services under Normal categories and Special categories.
The log is kept for their services. Anytime a contractor works, an entry is made into the log for hours worked and type of work.

I have values as shown below in columns A to J (as a sample). The actual data extends a couple hundred columns.

A B C D E F G H I J
1 N 0.5 N 0.5 S 2 S 2 N


It shows that the contractor provided "Normal" services 3 times and "Special" services 2 times.
I am looking for a formula that will calculate the SUM of hours spent under each category.

E.g for Normal(N) , the formula should return 3.5
i.e find the instances of N and add the value in the cell to the left of it.

NO VBA pls.
Any way to do it by just using functions??