ExcelBanter - How do I sum with a cell that is a formula

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

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

- - How do I sum with a cell that is a formula (https://www.excelbanter.com/excel-discussion-misc-queries/244493-how-do-i-sum-cell-formula.html)

NeverBoring

How do I sum with a cell that is a formula

One of the cells I wish to sum is a formula and does not sum. Thank you.

T. Valko

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.

All times are GMT +1. The time now is 07:16 PM.