Or if your actual data has a different structure but still consistent across board, you may be able to work out your own MID function to find the condition code within the data range and then do a SUM and COUNTIF to find the total number. This example illustrates the use of Ctrl SHIFT-ENTER in calculating the sum of sales generated for different products using the conditions. Once again, my solution will only work with the condition that the original data always have 4-Character prefix, 4-Character suffix, and 6-Character condition code. Please note it is an array formula so you need to press CSE Ctrl+Shift+Enter upon finishing the formula to make it work. Please note I have defined the following names in my example:ġ) Data range on the December 2013 Data sheet is named as Data_2013DecĢ) Condition code on the Heart-related Condition Codes sheet is named as Condition_Code Then you can use an array formula with the combination of SUM, COUNTIF and MID functions to find the desired result. L893 ( 4 characters prefix) + XXX ( random number of characters) + Condition Code ( 6Ĭharacters) + TGU3 ( 4 characters suffix) If your data on the December 2013 Data sheet has the same structure across board which is
0 kommentar(er)
