Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling values based on selection criteria
I have the following data A B C 1.0 1 1.5 1 1.0 1 2.0 1 1.0 1 2.0 1 I am looking to aggregate the values in column B based on the value in column A So I would need to be able to do Column A value 1.0 column B total 2 Column A value 1.0 column C total 1 Column A value 1.5 column B total 1 Column A value 1.5 column C total 0 Column A value 2.0 column B total 1 Column A value 2.0 column C total 1 Hoping that the answer for this would provide me the answer to do multiple selection criteria, but in case it would be different A B C D 1.0 ABC 1 1.5 DEF 1 1.0 ABC 1 2.0 XYZ 1 1.0 ABC 1 2.0 DEF 1 Column A value 1.0 column B value ABC column C total 2 Column A value 1.0 column B value ABC column D total 1 etc. Thanks for any advice, Bart |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling values based on selection criteria
Hi
try <something like =SUMIF(A:A,"1.0",B:B) for your first question. For your second one try =SUMPRODUCT(--(A1:A100=1.0),--(B1:B100="ABC"),C1:C100) -- Regards Frank Kabel Frankfurt, Germany Bartholomew Simpson wrote: I have the following data A B C 1.0 1 1.5 1 1.0 1 2.0 1 1.0 1 2.0 1 I am looking to aggregate the values in column B based on the value in column A So I would need to be able to do Column A value 1.0 column B total 2 Column A value 1.0 column C total 1 Column A value 1.5 column B total 1 Column A value 1.5 column C total 0 Column A value 2.0 column B total 1 Column A value 2.0 column C total 1 Hoping that the answer for this would provide me the answer to do multiple selection criteria, but in case it would be different A B C D 1.0 ABC 1 1.5 DEF 1 1.0 ABC 1 2.0 XYZ 1 1.0 ABC 1 2.0 DEF 1 Column A value 1.0 column B value ABC column C total 2 Column A value 1.0 column B value ABC column D total 1 etc. Thanks for any advice, Bart |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling values based on selection criteria
Frank.
Thanks. Bart "Frank Kabel" wrote in message ... Hi try <something like =SUMIF(A:A,"1.0",B:B) for your first question. For your second one try =SUMPRODUCT(--(A1:A100=1.0),--(B1:B100="ABC"),C1:C100) -- Regards Frank Kabel Frankfurt, Germany Bartholomew Simpson wrote: I have the following data A B C 1.0 1 1.5 1 1.0 1 2.0 1 1.0 1 2.0 1 I am looking to aggregate the values in column B based on the value in column A So I would need to be able to do Column A value 1.0 column B total 2 Column A value 1.0 column C total 1 Column A value 1.5 column B total 1 Column A value 1.5 column C total 0 Column A value 2.0 column B total 1 Column A value 2.0 column C total 1 Hoping that the answer for this would provide me the answer to do multiple selection criteria, but in case it would be different A B C D 1.0 ABC 1 1.5 DEF 1 1.0 ABC 1 2.0 XYZ 1 1.0 ABC 1 2.0 DEF 1 Column A value 1.0 column B value ABC column C total 2 Column A value 1.0 column B value ABC column D total 1 etc. Thanks for any advice, Bart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating values based on selection from drop down box | Excel Discussion (Misc queries) | |||
List box change values based on selection | Excel Discussion (Misc queries) | |||
Selection of Cells based on a criteria | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Selection based on values in a cell | Excel Programming |