I am using currency as my numbers for my cells, could this be giving me
problems?

ShaneDevenshire wrote:
Hi,

Hardcoding values into cells defeats the purpose of using Excel. As pointed
out you should enter the numbers in other cells and then let Excel sum those
cells. However, that is not the reason you are getting an error. In the
formula you list
=SUM(100,200,300,)
works just fine on my machine. So if it fails for you then you are not
showing us everything. The SUM function will allow up to 30 arguments in
2003 and 255 in 2007 so 12 months is not causing a problem.