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.
You use the SUMPRODUCT function to find out the row where both criteria are met, and return the corresponding row number using the ROW function. Then you use SUMPRODUCT in the INDEX function to return the value in the array C3:C13 that is in the row number provided.