Sum Weekend and Holiday Values Based on a Date Range in another Cell

Hello,

I have searched everywhere and can not find what I need. I need to sum weekend and Holiday values only and then the reverse, sum weekday values without holiday values. Here is a breakdown:

Column A (Dates)
Wednesday, August 1, 2012
Thursday, August 2, 2012
Fridays, August 3, 2012
(continued through to Monday, September 3, 2012)

Column B (Values)
Column C (Holiday Dates, defined as Holidays Range)

I can sum weekend values using:
=sumproduct(--(weekday(a2:a35,2)>5),(b2:b35))

I can sum the 1st Holiday value by using:
=SUMIF(A2:A35,Holidays,b2:b35) --> But, it does not loop through all the Holiday dates to produce a total sum.

The below formula returns a True value and it does loop through all the Holiday dates, but does not return the values in Column B:
=OR(SUM(b2:b35,MATCH(Holidays,A2:A35,0)))

Any help or suggestions is greatly appreciated.

I have attached a small sample of a larger workbook.

Thank you.

Thank you. It does sum the Holiday values. But, is it possible to combine your formula with what I have to sum weekend and Holiday together? Also, how can I subtract the Holiday values from my weekday values?

Sure,

This sums the holiday and weekend values:

Please Login or Register  to view this content.

and this sums the weekday values:

Please Login or Register  to view this content.

finally, this sums the weekday values and subtracts the holiday values:

Please Login or Register  to view this content.

Thank you so much! You have no idea how crazy this has been making me.