IF Statement, Ranges and SUM

  • Thread starter Thread starter paddy_nyr
  • Start date Start date
P

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.
 
paddy_nyr said:
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.
Click to expand...

=SUMIF(A1:A100,"soup",B1:B100)
 
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
Click to expand...

try it with Pivot-Table


Regards
Claus Busch
 
Back
Top