• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Addition formula

E

EldoFuoj

New Member
I am adding a range of cells =sum(A2:R2), and one of the cells in that range is pulling a number that has been input from another formula, so it is not adding that number into the final sum. The formula that it is pulling from looks like this: =IF(F2="Text",("8"),(F2)) Now if I do the =+A1+B2+C3+etc... it will work fine, but this is obviously time consuming.


Secondly, in that same range I have a cell that requires the text "AB", is there anyway that I can set the range to add all cells and completely ignore the text? All I keep getting is an error for the final cell, because that text "AB" is there.


Last, I have one cell that I have conditionally formatted to highlight if the letters "Time Off" are there. In the second sheet, I have a cell that will convert the text "Time Off" to the number "8", =IF(C2="PTO",("8"),(C2)) but I can't figure out how to get that cell to highlight also.
 
Eldofuoj


Firstly, welcome to the Chandoo.org forums


The numbers in your formula should not have "s around them

So your formula should be

=IF(C2="PTO",8,C2)


Using quotes converts the number to text and that's why it isn't adding up
 
Awesome, and thank you for the welcome. I have usually been able to find my answers with a search but this is the first time that I have had to actually post. That fixed my first two problems easily. Thank you so much.
 
You must log in or register to reply here.
Back
Top