Sum/Total based on 2 conditions

[chikanyc]

Hi,

I have a song and invoice databases for a company which licenses usage of songs in different tv shows.

I enter DURATION of a song by DATE OF AIR and by SEGMENTS in a SHOW.

I want to generate a total/summary of duration by DATE OF AIR & SHOW. e.g. the Primetime show that aired on 3/20/07 might have 5 different segments. i want the total duration for that Primetime show on 3/20/07 (adding all the segments).

What calc would I use?

Thanks!

Edited March 22, 2007 by Guest