Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
could you possibly send me a copy of the sheet
so I can get a visual idea of where the problem might be occuring
give me a minute to open it
The formula is in cell X12.
do you care for the lookup formulas
if it puts a 0 in when there is an error
instead of a blank
that will make the sum formula work
actually that is the only way to fix the sum formula
still with me?
actually yes that will fix it for you
change all of the iferror ""
to iferror 0
here is the modified file
PLEASE REMEMBER TO RATE MY SERVICE
and remember I am arround if you need anything else
Yes that works but then the 0 screws up with the data I am calculating etc. So I will then have to delete all the zeros or delete all the formulas from the blank cells.
I will see which way works best for me as either way it is a band aid fix. Thanks for your help.
i have another idea
if you can't have the zeros
if its only the 4 cells