Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there any way to have multiple TEXT criteria in a 'sumif' funct
I'm trying to run a sumif function from two different words in the same row
and then sum the range three cells to the right. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there any way to have multiple TEXT criteria in a 'sumif' funct
Let's see if I understand you correctly by way of this example:
You have a column of varying contents (Col_A) and another column containing numbers (Col_B). For each cell in Col_A that equals "Dave" or "Steve" you want to sum the corresponding values from Col_B For that scenario, this formula returns that sum: C1: =SUM(SUMIF(A:A,{"Dave","Steve"},B:B)) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "datasorter" wrote: I'm trying to run a sumif function from two different words in the same row and then sum the range three cells to the right. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
is there any way to have multiple TEXT criteria in a 'sumif' funct
Hi!
Try this: =SUM(SUMIF(A1:A10,{"word_1","word_2"},D1:D10)) Biff "datasorter" wrote in message ... I'm trying to run a sumif function from two different words in the same row and then sum the range three cells to the right. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif with multiple criteria | Excel Worksheet Functions | |||
Multiple SUMIF Criteria | Excel Worksheet Functions | |||
SUMIF With Multiple Criteria | Excel Worksheet Functions | |||
Justify text across multiple columns | Excel Discussion (Misc queries) | |||
SumIf Function using multiple criteria | Excel Worksheet Functions |