Wednesday, June 2, 2010

Spreadsheetard needs help.

Is there a better way to total the contents from a bunch of cells in Excel?

Look at this:

=SUM(E20,G20,I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20,BG20)

This spreadsheet does what it's designed to do, but really? WTF? Is this the way it's supposed to look? I've been using this for 2 years and it's in Excel 2003, but maybe upgrading to 2007 will give me more powers?

I know you all think I'm a super genius and all, but really, I can't even pull my socks on without bumping my head.