Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum by criteria
In the following example I need to sum column D for criteria in column B, and
sum column E for criteria in column B. A B C D E ACCT COMM STRIKE LONG SHORT 1 cf wz 2 2 df wz 2 3 ef wc 2 4 fk wh 4 5 ro wc 5 6 gl wc 3 7 lu wh 4 8 qw wh 3 9 gd wz 5 10 we wc 7 Example: For wc in column B and a number in column D, I need to sum for wc. For wc in column B and a number in column E, I need to sum for wc. And so on and so on, for matching criteria in column B. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum by criteria
Have a look at SUMIF in Help for single criteria (criterion, if you wish)
SUMPRODUCT can be used for multiple criteria, as can SUMIFS in Excel 2007 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chrisnsmith" wrote in message ... In the following example I need to sum column D for criteria in column B, and sum column E for criteria in column B. A B C D E ACCT COMM STRIKE LONG SHORT 1 cf wz 2 2 df wz 2 3 ef wc 2 4 fk wh 4 5 ro wc 5 6 gl wc 3 7 lu wh 4 8 qw wh 3 9 gd wz 5 10 we wc 7 Example: For wc in column B and a number in column D, I need to sum for wc. For wc in column B and a number in column E, I need to sum for wc. And so on and so on, for matching criteria in column B. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum by criteria
Do you mean this
=SUMIF(B:B,"WC",D:D) Mike "chrisnsmith" wrote: In the following example I need to sum column D for criteria in column B, and sum column E for criteria in column B. A B C D E ACCT COMM STRIKE LONG SHORT 1 cf wz 2 2 df wz 2 3 ef wc 2 4 fk wh 4 5 ro wc 5 6 gl wc 3 7 lu wh 4 8 qw wh 3 9 gd wz 5 10 we wc 7 Example: For wc in column B and a number in column D, I need to sum for wc. For wc in column B and a number in column E, I need to sum for wc. And so on and so on, for matching criteria in column B. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum by criteria
Thanks, that was pretty easy.
"Bernard Liengme" wrote: Have a look at SUMIF in Help for single criteria (criterion, if you wish) SUMPRODUCT can be used for multiple criteria, as can SUMIFS in Excel 2007 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "chrisnsmith" wrote in message ... In the following example I need to sum column D for criteria in column B, and sum column E for criteria in column B. A B C D E ACCT COMM STRIKE LONG SHORT 1 cf wz 2 2 df wz 2 3 ef wc 2 4 fk wh 4 5 ro wc 5 6 gl wc 3 7 lu wh 4 8 qw wh 3 9 gd wz 5 10 we wc 7 Example: For wc in column B and a number in column D, I need to sum for wc. For wc in column B and a number in column E, I need to sum for wc. And so on and so on, for matching criteria in column B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL - Meet 2 criteria, then find next case of third criteria | Excel Worksheet Functions | |||
=DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
Countif using format criteria not number criteria? | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |