Ive imported my Trial Balance into one tab. I want to analyse this information on other tabs in various ways and apply some simple sums to the values. But when I link these cells to my Trial Balance and there is no actual number I get an error if I try to apply a formula to it. It sees a blank as a space, not the absence of an actual value.
How do I sum a range of these cells when some are spaces. Is there a formula that I can use to copy the entire TB and only copy the values, ignoring the spaces ? Then this can be the TB I analyse.
Bookmarks