| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Modify SumIF... Array Formula
I am using this formula.
=SUM(IF((TMS2!$BL$3:$BL$60000<=WatchList!$A$4)*(TM S2!$K$3:$K$60000="050S0F1");TMS2!$F$3:$F$60000)) Is it possible to modify this part (TMS2!$K$3:$K$60000="050S0F1") to set the criteria to look for all cases where the cell equals 050S0F1, 050S0F2 ... 050S0FB. In other words, any cell where the left 6 characters are 050S0F ? Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count number of dates in an array | Excel Worksheet Functions | |||
| Array Formula | Excel Worksheet Functions | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
Hybrid Mode
