If cell equals, give total of another cell

L

Lori Burton

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?
 
B

BekkiM

Take the quotation marks out of the true value:

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