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

[STEVE]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[JMB]

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