formula for two worksheets

[camp732]

I need a formula that will get the sum of claims that incurred on a Monday,
Tuesday and so on from the claim detail worksheet. The amounts are in column
u7:u97.

 

[Squeaky]

Please explain how your sheets are set up better. Is the claim detail
worksheet a thrid sheet you are using to combine the totals of the first two?
Or are you looking for something that will total everything that occured on
every Monday totalled out, and every Tuesday totalled out, etc., and
totalling that on the second worksheet?

Squeaky