Do you have a column of dates?

You need to check the month of the date.

Where is the range that contains your dates?
Where is the range to sum?

--
Biff
Microsoft Excel MVP


"mon732" wrote in message
...
=sum('Claim Detail'!u$7:u$97,A30) - I can't figure out what the correct
formula would be to get the sum of all claims incurred in column u7:u97 in
the claim detail worksheet for each month of the year.