In EXCEL 2007 enter:-

2001 2002 2003 2005 2005

- in cells A 1 to E 1.

In cell F 1 enter:-

=SUM(A1:E1)

Total of 10015 gets returned to cell F 1.

Please hit Yes if my comments have helped.

Thanks.





"Lindsey" wrote:

I understand how sumif work veritically, but what if I want to sumif by rows
instead of columns?

Row A1 - AB1 are different years, 2001, 2002, etc. In row B1 - BB1, there
are numbers. I would like a formula that sums up the different years.

I would transpose the data, but it needs to be in this format to work with
another software.

Thanks in advance for your help!