Look at SUMPRODUCT

Something like:

=SUMPRODUCT(--(A2:A68="client")*--(B2:B68="status")*--(C2:C68="type")*--(D2:D68))

Adjust the columns and rows to suit

Regards

Trevor


"MNSNOWGAL" wrote in message
...
I've got 3 columns where I want that info to be "true" and if it is, then
calculate the numbers in the 4th columns for those rows that met the 3
sets
of criteria.

So, if 1) client, 2) status, and 3) type meet my criteria, then I want to
sum the numbers in another column.

I'm going around in circles. Can anyone point me in the right direction?

Thanks much!!