If cell equals, give total of another cell

G

Guest

I have a formula that looks likes this:

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

If true, it returns "Historical!A10"

How do I write this formula to give me the value of A10 and not the name of
the cell?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If cell equals, give total of another cell 2
Excel 2007 storing the high and low 3
I think an easy Conditional Formatting ? 4
Disable Cell 5
Formula to find the last number of a column (lower cell) 1
Copying a Cell 1
Maximum and Minimum of a cell that changes 2
=ABS 4

Top