View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Need help with a SUM formula...

On Thu, 15 Nov 2007 11:36:00 -0800, Christina
wrote:

I'm trying to sum up a column but one of the cells in the sum range has an IF
formula in it. I need the total sum to include the value of this cell. When I
do the simple sum formula it doesn't include it in the total. How do I get
this to work for me??

Thanks!


Post the IF formula. Probably it's returning text instead of a number.
--ron