| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif with 2 variables
i want to create a formulae to sum a range of numbers in a column providing
two conditions are met in other columns. I can do it using SUMIF for one condition ie. SUMIF(A14:A401,R5,B14:B401) but how do you add in a second criteria to also be met before the cells B14:B401 are added something like SUMIF(A14:A401,R5 and C14:C401,T6 then sum B14:B401) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif with 2 variables
=SUMPRODUCT((A14:A401=R5)*(C14:C401=T6)*B14:B401)
-- David Biddulph "Dave" wrote in message ... i want to create a formulae to sum a range of numbers in a column providing two conditions are met in other columns. I can do it using SUMIF for one condition ie. SUMIF(A14:A401,R5,B14:B401) but how do you add in a second criteria to also be met before the cells B14:B401 are added something like SUMIF(A14:A401,R5 and C14:C401,T6 then sum B14:B401) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif with 2 variables
=SUMPRODUCT(--(A14:A401=R5),--(C14:C401=T6),B14:B401) If you have Excel 2007, you can use SUMIFS =SUMIFS(B14:B401,A14:A401,R5,C14:C401,T6) -- __________________________________ HTH Bob "Dave" wrote in message ... i want to create a formulae to sum a range of numbers in a column providing two conditions are met in other columns. I can do it using SUMIF for one condition ie. SUMIF(A14:A401,R5,B14:B401) but how do you add in a second criteria to also be met before the cells B14:B401 are added something like SUMIF(A14:A401,R5 and C14:C401,T6 then sum B14:B401) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif with 2 variables
Thanx David,
spot on. "David Biddulph" wrote: =SUMPRODUCT((A14:A401=R5)*(C14:C401=T6)*B14:B401) -- David Biddulph "Dave" wrote in message ... i want to create a formulae to sum a range of numbers in a column providing two conditions are met in other columns. I can do it using SUMIF for one condition ie. SUMIF(A14:A401,R5,B14:B401) but how do you add in a second criteria to also be met before the cells B14:B401 are added something like SUMIF(A14:A401,R5 and C14:C401,T6 then sum B14:B401) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF with two or more variables | Excel Worksheet Functions | |||
| SUMIF formula for two variables in two columns | Excel Worksheet Functions | |||
| Sumif with multiple variables | Excel Discussion (Misc queries) | |||
| SUMIF Formuale with 2 variables | Excel Worksheet Functions | |||
| SUMIF variables | Excel Discussion (Misc queries) | |||
Linear Mode
