ExcelBanter - If cell equals, give total of another cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If cell equals, give total of another cell (https://www.excelbanter.com/excel-discussion-misc-queries/64750-if-cell-equals-give-total-another-cell.html)

Lori Burton

If cell equals, give total of another cell

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

CLR

If cell equals, give total of another cell

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

Vaya con Dios,
Chuck, CABGx3

"Lori Burton" wrote:

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

All times are GMT +1. The time now is 06:27 PM.