Since you are using Excel 2003, try this array formula... =SUM((A:A="samedata")*(B:B="samedata2")*C:C)

Make sure to use array enter (CTRL-SHIFT-ENTER) instead of just enter...

Let me know if this works for you...

Dennis