Thread: If cell equals, give total of another cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lori Burton
 
Posts: n/a
Default If cell equals, give total of another cell
I have written a formula that looks like this:

=IF(Historical!I10="X","value(Historical!A10)","")

The true value returns "Historical!A10" rather than the value showing in the
cell. How do I fix this?
--
Lori
Reply With QuoteReply With Quote