Sum formula with multiple criteria

[gingertom]

Hello,

I wonder if someone can help me. I have a spreadsheet, that I use for a weekly report, it has over a dozen tabs and a summary page. I need to collate information from the 'rep' tabs into the summary sheet; at the moment I do this manually and it is very time consuming.

I'm wanting to calculate how many sales have been completed for 'Course 1' within 'Course Type 1' (they're my two criteria); the forumla will be based on the 'totals' tab in cell C3. I've included images below.

Image 1:
[/url]
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Image 2:
[/url[/COLOR]]

Any help you can give would be greatly appreciated.

Regards,

Tom

 

[gingertom]

Sorry, it appears I didn't enter the correct code for the image link. It's been a while since I've been on a forum, plus my works internet is very restrictive!

Here's my second attempt

Image 1:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Image 2:


Cheers,

Tom