Good Morning,

I have a file that shows text and numbers in the same column. I want to do a sumif formula that will only return totals for those items in the column that are values, not text.

Ex.

Bread $15
123 $11
234 $2
345 $2

I want the sumif to result in $15 no $30 based on the sample table above.