Note: If you use the * operator to multiply arrays before passing the
resulting array to SUMPRODUCT to sum, the double negatives are not
necessary:

=SUMPRODUCT((A2:A68="client")*(B2:B68="status")*(C 2:C68="type")*
(D2:D68 8))

OTOH, if you pass the arrays to SUMPRODUCT(), which is slightly more
efficient, you need to coerce the TRUE/FALSE arrays to 1/0 using --


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

See

http://www.mcgimpsey.com/excel/doubleneg.html

for a more detailed explanation.


In article ,
"Trevor Shuttleworth" wrote:

Look at SUMPRODUCT

Something like:

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

Adjust the columns and rows to suit