There are several types of treatments and medical providers for which Medicare Part B pays 100% of the approved charges rather than the usual 80%, and to which the yearly Part B deductible does not apply. In these categories, you are not required to pay the regular 20% coinsurance amount.
Mulei-Cell Array Formulas. A multi cell array formula is used when the result of the formula is a range that takes up more than one cell. Some Excel functions are required to be entered this way as multi-cell array formulas making use of Ctrl+Shift+Enter, the most common of which is TRANSPOSE.
This Excel tutorial explains how to use an array formula to count the number of rows that match two criteria in Excel 2003 and older versions (with screenshots and step-by-step instructions). Sheet1 has 0-to-many rows for one city (one row for each case opened in that city).