Hi,

I'm trying to automate an excel file.

I have a range of 53 columns where i want to count the range of A1+B1 iff the value is 2, and so it has to continue to the right B1+C1

If the value is 10 the sum has to be A1:J1 and for the next cell in the row B1:K1

Does anyone have a formula for that?

Thanks in advance.

Jens