Hi,

we need to know more, what do you mean Correct pick = checkmark? What is
actually in the cells on a given row? You say add 20 but then you are
multiplying by 20, which are you trying to do? Show us a line of sample data.

For example, if cell E32 contains X and the next cell contains checkmark,
whatever that is, should we add $20. If there are four X's in a row do we
add 3*20 or just 20. One problem for example suppose AJ32 has an X, then
technically there is only one cell that follows it that can be <"" but your
formula checks the entire range from F32:AK32. So if F32 is <"" but does
not contain an X but AJ32 contains an X this formula pays $20, is that what
you want?

--
Thanks,
Shane Devenshire


"William17" wrote:

Hey all need some help correcting this formula

=SUMPRODUCT(--(E32:AJ32="x"),--(F32:AK32<""))*20+C32

How it works is follow

Correct pick =checkmark

Incorrect pick = X

If X is followed by anther selection then multiple it by $20

The problem Im having is if the result is X and I skip one cell its not
adding the $20
Even if I skip one cell it should add the $20 if another pick is adding
along this cell area.

Thanks ahead