Compiling values based on selection criteria

[Bartholomew Simpson]

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

 

[Frank Kabel]

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)

 

[Bartholomew Simpson]

Frank.

Thanks.

Bart

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)