Excel SUM Help - Printable Version +- [TC] Gaming Forums (https://forum.city-driving.co.uk) +-- Forum: Community Area (/forumdisplay.php?fid=14) +--- Forum: Technology Area (/forumdisplay.php?fid=82) +---- Forum: Tech Support (/forumdisplay.php?fid=85) +---- Thread: Excel SUM Help (/showthread.php?tid=7063)

Excel SUM Help - Ash - 2013-05-21 13:00 Hi guys. Basically, im having trouble with one of the most basic forumlas in excel lol Right, ive got in a column a list of numbers which are made up from a formula inside each cell. When i go to do =SUM(G3:G52), it returns 0 even though there is NUMERICAL data showing in the highlighted cells. Because cells G3 to G52 are actually formulas, will =SUM not work? Cheers Ash RE: Excel SUM Help - Kayla - 2013-05-21 13:58 G3 and G52 must have numbers in them obviously, if the numbers come from a formula or not, =SUM doesn't care. At least not in my experience with Excel. RE: Excel SUM Help - Dan - 2013-05-21 15:01 What Michi said. Regardless of how the numbers got there, providing they exist, the formula(es) you will be using in the future should still work. RE: Excel SUM Help - Ash - 2013-05-21 15:14 Hmmmm odd.... The total adds upto well in excess of 600, but the sum formula just returns 0 :/