It is partially correct, except that I am looking for

A OR B OR C AND E
then Sum D2:D30

and I still am not able to figure out!

Thanks!

"Pete_UK" wrote:

I think an IF - SUM is what you want. Try this:

=IF(OR(A2="condition", B2="condition",C2="condition"),sum(D2:D30),0)

Hope this helps.

Pete