Hours and Money Columns

[thestones757]

I am recording my work schedule in a money spreadsheet, I have all of the data for shift date, time, hours, pay, money, etc. Then in a new chart I am representing Weekly Values such as number of shift, hours, and money. I have the weeknum function as a pivot and then I was able to manipulate the shifts through countif but I am trying to represent the hours and money. So far I have the following function:

=IF(D3:D400=Q3,

This is if the week number of my raw data = the week number in my pivot, then I need to sum the hour totals in column G but how can I only sum the ones that have the ones that have the weeknum I am looking for. Same question for money column too. Thanks!