Thread: SUMPRODUCT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William17 William17 is offline
external usenet poster
 
Posts: 2
Default SUMPRODUCT

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