View Single Post
  #1   Report Post  
construction guy
 
Posts: n/a
Default How do I sum currency only numbers in a range?

I would like to sum a range of cells, only ignoring non-currency values.
e.g.: 5 10 $4 6 sum = $4