View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
meliswi3
 
Posts: n/a
Default How do I sum text cells with number cells?

I am trying to sum a range of cells with money with a range of cell's with a
name. For example, I want to find all the cell's with the name Lange's in it
and have it sum the total's for what I spent at Lange's. I've tried SUMIF
but it didn't seem to work...Please help