Following this asterisk, enter your second range of cells. You'll be multiplying this second range of cells by the first. Your progress in this formula should now look like this Ready to press Enter? Not so fast ... Because this formula is so complicated, Excel reserves a different keyboard command for arrays. Once you've closed the parentheses on your array formula, press Ctrl+Shift+Enter. This will recognize your formula as an array, wrapping your formula in brace characters and successfully returning your product of both ranges combined.
Excel array formula In revenue calculations, this can cut down on your time and effort significantly. See the final formula in the screenshot above. 9. COUNT The COUNT formula in Excel is denoted =COUNT(Start Cell:End Cell). This formula will return a value that is equal to the number of entries found within your desired range of cells. For example, if there fax number list are eight cells with entered values between A1 and A10, =COUNT(A1:A10) will return a value of 8. The COUNT formula in Excel is particularly useful for large spreadsheets, wherein you want to see how many cells contain actual entries. Don't be fooled: This formula won't do any math on the values of the cells themselves. This formula is simply to find out how many cells in a selected range are occupied with something. Using the formula in bold above, you can easily run a count of active cells in your spreadsheet.
The result will look a little something like this: count-formula-in-excel 10. AVERAGE To perform the average formula in Excel, enter the values, cells, or range of cells of which you're calculating the average in the format, =AVERAGE(number1, number2, etc.) or =AVERAGE(Start Value:End Value). This will calculate the average of all the values or range of cells included in the parentheses. Finding the average of a range of cells in Excel keeps you from having to find individual sums and then performing a separate division equation on your total. Using =AVERAGE as your initial text entry, you can let Excel do all the work for you. For reference, the average of a group of numbers is equal to the sum of those numbers, divided by the number of items in that group. 11. SUMIF The SUMIF formula in Excel is denoted.