Sumif Horizontal
 

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!

Sumif Horizontal
 

Row A1 - AB1 are different years, 2001, 2002, etc.
In row B1 - BB1

Hmmm...

Those ranges don't make sense.

Do you mean that in every other cell there is a year number and you want to
sum the values to the immediate right of the year number cell?

Something like this:

2002 | 10 | 2009 | 20 | 2010 | 5 | 2002 | 50 |

The sum for year 2002 would be 60, 10+50.

Is that what you have?

--
Biff
Microsoft Excel MVP


"Lindsey" wrote in message
...
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!

Sumif Horizontal
 

SUMIF is not direction dependent.

Eg,
=SUMIF(1:1,"2009",2:2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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!

Sumif Horizontal
 

In EXCEL 2007 to sum by row:-

1. In cells A 1 to E 1 enter 1 2 3 4 5.

2. In cell F 1 enter:-

=SUM(A1:E1)

Total of 15 is returned in cell F 1.

If my comments have helped please hit Yes.

"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!

Sumif Horizontal
 

If the first two rows look like:

2001 2002 2007 2007 2009 2001 2005
1 5 5 2 8 10 9

then something like:
=SUMPRODUCT(--(A1:AB1=2007)*(A2:AB2))
correctly displays 7
--
Gary''s Student - gsnu201001


"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!

Sumif Horizontal
 

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!

Sumif Horizontal
 

Maybe something like that:
http://img697.imageshack.us/img697/2219/nonameg.png
Micky


"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!