=sumproduct((a2:a22="???")*(b2:b22="this")*c2:c22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"UCfts" wrote in message
...
I have a spread sheet with approx 3000 rows of info

The columns A and D of information have thee the criteria I would like to
use.
Column A is a 4-character alpha-numeric field
Column D is a Alpha field

For each instance of the value in column A which meets the criteria in
colum
D, I need to SUM column C.

Can anyone help?