How to reference cells ... arguments, so you can apply this next section’s information well beyond COUNTIF() functions. returns the highest commission for 2021. We now have everything we need ...

Microsoft Excel ... A Function Arguments dialog box will open. Follow the same method in Method 1. Type into your cell =ROWS(D1:F4). The result is 4, which is the number of rows in the reference.