Sure...

=SUMPRODUCT((RangeA="Criterion")*(RangeB="Criterio n")*(RangeC="Criterion"
)*(RangeToSum))

Remove the quotes if your criterion is a numerical value.

Hope this helps!

In article ,
"nc" wrote:

Thanks Domenic.

Can this function be adapted to use more than one criteria.