Thread: How do I sum with a cell that is a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How do I sum with a cell that is a formula
Remove the quotes from around any numbers in your formula.

Right:

=IF(A1="x",10,0)

Wrong:

=IF(A1="x","10","0")

--
Biff
Microsoft Excel MVP


"NeverBoring" wrote in message
...
One of the cells I wish to sum is a formula and does not sum. Thank you.


Reply With QuoteReply With Quote