Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif / Countif
Hi
is there any way that i can use 2 arguments for sumif & countif functions instead of just 1? -- Lois |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif / Countif
Sorta. You need to use the SUMPRODUCT formula
Example of summing everything that corresponds to "tom" or "bob" =SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob"))*(B2:B10 ) Conditions in multiple columns (Bob in column A, Car in column C =SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car")*(B2:B10) ) Similarly, a count of instances of Bob in column A, Car in column C =SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car")) Or count in same column =SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob")) Note that you can't callout entire columns (A:A), and ranges must be the same size. Also, XL 2007 introduced SUMIFS and COUNTIFS, which allows multiple criteria. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Blue" wrote: Hi is there any way that i can use 2 arguments for sumif & countif functions instead of just 1? -- Lois |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif / Countif
Yes, SUMPRODUCT. Countless examples can be seen in the archives of this
newsgroup. -- David Biddulph "Blue" wrote in message ... Hi is there any way that i can use 2 arguments for sumif & countif functions instead of just 1? -- Lois |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif / Countif
If you are using xl2007, you can use SUMIFS, and COUNTIFS functions
"Blue" wrote: Hi is there any way that i can use 2 arguments for sumif & countif functions instead of just 1? -- Lois |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From SUMIF to COUNTIF | Excel Worksheet Functions | |||
sumif or countif not sure | Excel Worksheet Functions | |||
COUNTIF?? SUMIF?? | Excel Discussion (Misc queries) | |||
Countif, Sumif | Excel Worksheet Functions | |||
Countif, Sumif, If - help! | Excel Worksheet Functions |