=sumproduct(--(A1:A64000=Criteria A),--(B1:B64000=Criteria
B),--(C1:C64000={criteria c1,Criteria C2,Criteria C3}),D1:D64000)
the "--)" changes the loogical true false to a numeric 1 0
the arrays must be the same size and cannot refer to a complete column A:A
will not work

"jkl" wrote:

Text data is listed in column A, B, and C. Numerical data in column D. I
need to total the values of the numbers in column D for those instances in
which column A has a particular text value, column B has a particular text
value, AND column C has any one of three text values.

Thanks in advance . . .