Adding numbers in a range

G

gd

Hello,
I am wondering if there is an easy way to do this. If excel supports with a
method.

If I have a range. Maybe A1 to B20
Lets say column A has a word in it. And column B has numbers.
So maybe like this

aaa,4
aaa,7
bbb,9
bbb,3
bbb,4
ccc,4
ddd,5


Is there a way to add up all the bbb numbers? Using this range?

thanks
 
E

Eduardo

Hi,
Try
=SUMPRODUCT(--(A:A="bbb"),B:B)

I recommend to enter bbb or aaa in a cell and then refer to that cell in
your formula for example cell c1

=SUMPRODUCT(--(A:A=$c$1$),B:B)

If you are not using excel 2007 give a range to the parameters

=SUMPRODUCT(--(A1:A1000="bbb"),B1:B1000)

If this was helpful please say yes. thanks
 
L

Luke M

Indeed, there is. For more info, try XL's help file on SUMIF (or COUNTIF)

=SUMIF(A1:A20,"bbb",B1:B20)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selective Range extraction depends on the cell outcome 10
easy way to fill out a range with formulas? 9
At each change in data apply formula 4
VBA Conditional formating for specific text in several columns 1
Dynamic Range Name Anomalities 4
Concatinating two spreadsheets by a column 4
Lookup and store in array 1
Select sheets based on what is in a range. 6

Top