How do I sum values in a row if the value in a row above = text
 

How do I sum apecifif values in a row g13:ag13 if g11="H"?
So if g11 and aa11 = "H", it would return the sum of g13+aa13

How do I sum values in a row if the value in a row above = text
 

=IF(AND(G11="H",(AA11="H")),G13+AA13)


Gord Dibben MS Excel MVP

On Sat, 7 Oct 2006 16:45:02 -0700, STEVE
wrote:

How do I sum apecifif values in a row g13:ag13 if g11="H"?
So if g11 and aa11 = "H", it would return the sum of g13+aa13

How do I sum values in a row if the value in a row above = text
 

try
=SUMIF(G11:AA11, "H", G13:AA13)

"STEVE" wrote:

How do I sum apecifif values in a row g13:ag13 if g11="H"?
So if g11 and aa11 = "H", it would return the sum of g13+aa13