Sum calculation for a row excluding some columns

[yeahyeah93]

Hi,

I need a sum formula that will help me to get the total number in a row that excludes multiple columns.

I have attached the example.
The columns i need to be excluded are in light red and the cell i need to populate with the total is the YTD.

The light red columns cannot be counted as they are a total of the number of incidents in that week range and are used for graphs.

[:) Sixthsense :)]

In C5 Cell

=SUMIF($D$4:$OL$4,"<>T",D5:OL5)

Drag it down...