Markus

You can use an array expression (which means, after entering the formula
below, you need to hit CTL-SHFT-ENTER instead of just ENTER).

=SUM(D5*(E5="601"), F5*(G5="601"),H5*(I5="601"),J5*(K5="601"))

If you do it right, the "{}" brackets will appear around the expression in
the edit window at the top when this cell is selected.

Will

"Markus" wrote:

Hi,
I hope someone can give me a hand here.

I have the following:

D E F G H I J K
5 10 601 8 601 3 614 4 601

I want to program a cell that will add up D5, F5, H5, J5 only if text in E5,
G5, I5 and K5 is "601", so that my result should be 22

Thanks for your assistance

Markus