Thanks Will,

I didn't get much success with the commas (",") between the brackets. The
colored square cells didn't come up while they did using ";"...I followed
your instructions except for using ";" otherwise it returned an error. But
event with the semi colon, I get 0 even if I have data in the right cells.

Any ideas ?

Thanks for your help.

"roadkill" wrote:

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