Just three easy steps. // 1  Heat pancake griddle to 375Â°F (medium heat). Lightly grease griddle. // 2  Stir pancake mix and water together with a wire whisk. Batter will be slightly lumpy. // 3  Cook pancakes 1- 1 1/4 minutes per side, or until golden brown, turning only once.
This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for any number. 1. The ROW function returns the row number of a cell. 2. The MOD function gives the remainder of a division. For example, for the first row, MOD(1,3) equals 1. 1 is divided by 3 (0 times) to give a remainder of 1.
After you filter the rows in a list, you can use the SUBTOTAL function to count the visible rows. 1  Apply an AutoFilter to the table. 2  Filter at least one of the columns in the table. 3  Select the cell immediately below the column you want to sum. 4  Click the AutoSum button on the Excel's Standard toolbar.