Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |