calculating a sum on non adjacent cells across a row

[dcgrove]

Hello, Please see the attatched spreadsheet. I can not seem to figure out a formula that will calculate the totals for each type of data. My goal is to have a sum for each location for # of audits, Critical Counts, and Major Counts. Any help would be greatly appreciated.

Thanks!
dcgrove

[daddylonglegs]

Try using SUMIF, i.e. this formula in T3

=SUMIF($F$2:$S$2,T$2,$F3:$S3)

copy across to V3 and then down the column

[dcgrove]

That worked! Thanks. I have never used the sumif formula as I just recently moved to 2007.