Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Help with SUMPRODUCT please : ) | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Help with SUMPRODUCT | Excel Discussion (Misc queries) | |||
sumproduct? | Excel Worksheet Functions |