IF Statement, Ranges and SUM

[paddy_nyr]

Hi,

I have a spreadsheet where in I want to check the value in column A
and then find the associated value in column B
and SUM up.

For example:

Col A Col B

Soup 10
Cake 10
Soup 10
Cake 10

So I want to check the range of col A for Soup and return the value of
20. Currently my if statement is returning 40.

 

[joeu2004]

I have a spreadsheet where in I want to check the value
in column A and then find the associated value in column B
and SUM up. [....]
So I want to check the range of col A for Soup and return
the value of 20.

=SUMIF(A1:A100,"soup",B1:B100)

 

[Claus Busch]

Hi Paddy,

Am Wed, 26 Oct 2011 13:40:14 -0700 (PDT) schrieb paddy_nyr:

I have a spreadsheet where in I want to check the value in column A
and then find the associated value in column B
and SUM up.

For example:

Col A Col B

Soup 10
Cake 10
Soup 10
Cake 10

try it with Pivot-Table


Regards
Claus Busch