| 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) | |||
Hybrid Mode
