How do I sum with a cell that is a formula

T

T. Valko

Remove the quotes from around any numbers in your formula.

Right:

=IF(A1="x",10,0)

Wrong:

=IF(A1="x","10","0")
 

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

How to Update SUM formula after inserting rows 2
Concatenate, currency & sum formula 2
Help Writing a SUM Formula 5
Multiple IF Statement in Word 5
Formatting question: how to format duration (time spent)? 0
if cell is blank 8
Copy addition formula of non-consecutive horizontal cells 2
Need help with Excel Formula for calculating sum of products depending on criteria 3

Top