SUM help

[imann101]

Hey, I haven't really worked with excel in a while but I know the basic functions so I am not a complete idiot. However, I am stuck here. I have 2 columns, one is a store name and the other is a price. How would I write a function to give me the sum of one of the stores. Example:


BC-------------$10
BC-------------$8
N---------------$10
BCG----------$5
BC------------$7
B--------------$6

I want to write a function in a separate column that adds all of the BC etc.

Thanks for your help!

Ian

[NBVC]

=Sumif(A1:A6,"BC",B1:B6)

Adjust ranges to suit

[teylyn]

Hi,

use the SUMIF function

=SUMIF(range, criteria, sum_range)

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

this will give you the sum of all the values in B1 to B100 where the corresponding cell in Column A has the text "BC"

HTH

Teylyn

[imann101]

Awesome, thanks