Formula:
```excel
=SUMIF(range, ">"&0)
```
Explanation:
* range: This is the range of cells you want to sum.
* ">"&0: This is the criteria for the SUMIF function. It tells the function to only sum cells that are greater than 0. This effectively excludes any text or blank cells.
Example:
Let's say your numeric values are in cells A1 to A10. You want to place the sum in cell B1. The formula would be:
```excel
=SUMIF(A1:A10, ">"&0)
```
This formula will add all the numeric values in cells A1 to A10, ignoring any text or blank cells. The result will be displayed in cell B1.
Note: This formula works by checking if the cell value is greater than zero. This assumes that your numeric values are always positive. If you have negative values, you can use the following formula instead:
```excel
=SUMIF(range, "<>")
```
This formula will sum all cells in the range that are not blank, effectively including both positive and negative numeric values.
