Yes, you are correct! You can use the
and
functions together to sum only the numbers in a range. Here's how:
- Select the cell where you want the sum to appear.
- Type the following formula:
Code:
=SUMIF(K:K,ISNUMBER(K:K),K:K)
- Press Enter.
This formula uses the
function to add up the values in column K that meet a certain criteria. The criteria is defined by the
function, which returns TRUE for any cell in column K that contains a number. So, the
function only adds up the cells in column K that are numbers.
Note that the formula uses the entire column K as the range to check for numbers. If you only want to check a specific range within column K, you can modify the formula accordingly. For example, if you only want to check cells K2:K10, you would use the following formula:
Code:
=SUMIF(K2:K10,ISNUMBER(K2:K10),K2:K10)