Summarizing a column in a report is only giving me a sum of half the data

I built a report from two separate sheets using a row report. I intend to add onto this weekly. When I try to total the sum of one column it's only giving me the value of half of the data.

It's only giving me the total amount from the bottom half. Is there another way to group this information?

In both sheets I've named the columns the same thing and they are formatted the same way as just text. There isn't anything fancy about them. I'm going to group the report by the week of the year so I know how many hours were used that week.

I

Answers