Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif
In the sumif function is there any way of having two
criteria. =sumif(Portfol!AF:AF,"21",Portfol!W:W) for example the criteria here is "21" chosen from column AF I also need "A" chosen from column K. Basically is there a formula that can have 2 criterias to get a sum of data. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif
=SUMPRODUCT((AF2:AF100=21)*(K2:K100="A")*(AG2:AG10 0))
Change Ranges to accomodate your data; Also Column AG is what you are "totaling/summing". HTH "Rich" wrote in message ... In the sumif function is there any way of having two criteria. =sumif(Portfol!AF:AF,"21",Portfol!W:W) for example the criteria here is "21" chosen from column AF I also need "A" chosen from column K. Basically is there a formula that can have 2 criterias to get a sum of data. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif
that was great it works thanks a lot
-----Original Message----- =SUMPRODUCT((AF2:AF100=21)*(K2:K100="A")*(AG2:AG10 0)) Change Ranges to accomodate your data; Also Column AG is what you are "totaling/summing". HTH "Rich" wrote in message ... In the sumif function is there any way of having two criteria. =sumif(Portfol!AF:AF,"21",Portfol!W:W) for example the criteria here is "21" chosen from column AF I also need "A" chosen from column K. Basically is there a formula that can have 2 criterias to get a sum of data. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF | Excel Discussion (Misc queries) | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |