T
TK
Question:
I have several workbooks linked to each other, each one populating the other
with data. I am trying to write a function that will give me quarterly
numbers by summing the months in the quarter, but only if the months in that
particular quarter have values. However, I think because all cells with
monthly data contain functions, the cells whose function returns no value are
not being recognized as blank. I have tried many IF statements, but have not
found one that works. If I have not clearly stated my problem, please tell
me what you need to know. Any suggestions would be a great help. Thanks.
I have several workbooks linked to each other, each one populating the other
with data. I am trying to write a function that will give me quarterly
numbers by summing the months in the quarter, but only if the months in that
particular quarter have values. However, I think because all cells with
monthly data contain functions, the cells whose function returns no value are
not being recognized as blank. I have tried many IF statements, but have not
found one that works. If I have not clearly stated my problem, please tell
me what you need to know. Any suggestions would be a great help. Thanks.