Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here is what I have as a function for cell J8, for example:
=7.75*SUMPRODUCT(--NOT(ISNA(MATCH(E8:H8, {"LA";"PD";"EA";"PDX";"MC";"V";"PR"},0)))) But, I need to include cell I8 into the calculation, but it would be multiplied by 4.75, instead of 7.75. What I'm doing, basically, is to determine the occurences of 7 different text strings in cells E8:I8, but I8 needs to be multiplied by 4.75, rather than 7.75. There may be a simple answer, but I don't know how. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |