Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link Protected WorkBook ... and Get #N/A for Text Values! | Excel Discussion (Misc queries) | |||
Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
How do I LOOKUP text values | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
text and values combined in one cel | Excel Discussion (Misc queries) |