Is there a formula or function that will add the number of hours (by row)
based on category. Meaning if I create another worksheet and had the
information put into these cells can I get it to add together the number of
hours based on the category by row and give me a total number of hours by
category.

MONDAY TUESDAY
A2= Name B2= $$ C2= Cat D2= Hours E2= Cat F2= Hours
A3= C3= Cat D3= Hours E3= Cat F3= Hours
A4= Name B4= $$ C4= Cat D4= Hours E4= Cat F4= Hours
A5= C5= Cat D5= Hours E5= Cat F5= Hours
A6= Name B6= $$ C6= Cat D6= Hours E6= Cat F6= Hours
A7= C7= Cat D7= Hours E7= Cat F7= Hours

The reason for the blank spaces is that generally 1-person does 2 different
categories per day and therefore they general have say 4 hours at cat1 and 4
hours at cat2 just as an example. In addition, in the cells where I have
indicated $$ there would be a dollar amount there like $15.00.

Lets say the other worksheet looked like this:

A1= CAT 1
A2= SUM OF ANY CAT1 HOURS FOR THIS ROW, AND FOR THE ROW DIRECTLY BELOW IT
(A3)
A3= B2 $$ * SUM OF CAT HOURS FROM ROW DIRECTLY ABOVE

This same scenario would need to go into the next columns for however many
categories (generally not more then 6) and it would need to accomplish the
same thing but for the different categories. I.E. CAT2 etc. Then be able to
go for as many as 20 rows down, and then making a total row with total hours
and dollars by category.

I tried to explain this the best way I though possible. I do hope for some
direction or if this is even possible. Thanks so much in advance!