| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas referencing a spaces instead of number ?
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. -- Ainsley ------------------------------------------------------------------------ Ainsley's Profile: http://www.excelforum.com/member.php...o&userid=31960 View this thread: http://www.excelforum.com/showthread...hreadid=538042 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why the date convert to number when i choose formulas from options | Excel Discussion (Misc queries) | |||
| Allow relative referencing for imbedded sheetnames in formulas | Excel Worksheet Functions | |||
| COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? | Excel Worksheet Functions | |||
| Changing a formulas result to be a static number | Excel Discussion (Misc queries) | |||
| Equation Referencing Row Number Stored in Cell | Excel Discussion (Misc queries) | |||
Threaded Mode
