Excel 2007 : Formula required for mutiple sheet increments on one "Summary" page

Hi

I currently have a workbook which holds information on issues expereinced if they were a priority 1 or 2 issue, ona specific contract and service.

I have been asked to produce a summary for the year. Just wanted to know if its possible to have a formula or set of formulas which provide a running total when they are entered on a daily basis...month on month.

Three key data elements need to be used

Severity Level - 1 or 2
Contract - C1 C2 or C3
Service - S1 S2 S3 S4 S5 S6...etc

I have created a summary page, but now want the summary page to automatically increment when we enter anything into Column A, including or lower than row 2.

The "Severity Level" neesd to be read so the forumal recognises if it's a "1" or a "2". The "Contract" column needs to be recognised so the summary sheet knows which contract cell to increment (based on severity), followed by the "System Affected" column, so it knows which system for that contract to increment(finishing in the right service, in the right contract with the right severity level being incremented by 1).

Hope this makes sense. I have attached the workbook, so it hopefully makes it clearer. This will be required to work for future sheets.

Ive tried to get formulas to recognsie it from my previous thread, but this is slightly different, and have been racking my brain out on conditional formatting with AND statements.

Any help is much appreciated

Kind Regards