Diagnostic daytime multiple sleep latency test (MSLT) is used to diagnose narcolepsy and to measure the degree of daytime sleepiness. It measures how quickly you fall asleep in quiet situations during the day. It also monitors how quickly and how often you enter REM sleep.
Array formulas provide a way by which Excel users can discover such useful information. To explain the power of array formulas I'll use this database. It shows sales by Seller, Product, Region, and Customer, with Quantity and Total Sales, in dollars. I named each column of data with the label shown in row 1.
If you want to use the SUM function on only the odd rows or the even rows in a range, you can use the following formulas. Enter the following formula as an array formula in cell A4:The formula returns a value of 2.hen you use any of the worksheet functions in Excel, and you have a range argument that includes either hidden rows or columns, the cells in these hidden areas are still used by the function.