Hi
try
=SUMPRODUCT(--(A1:A100="cond1"),--B1:B100="cond2"),--
(C1:C100="cond3"),D1:D100)

-----Original Message-----
needs help with excel. i need to write a formula to check
3 columns and then sum the 4th column if ther value of
the
3 columns are true.
.