gd;221682 Wrote:
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
Have a look at the SUMIF function.
Check XL's help for syntax
--
Pecoflyer
Cheers -
*'Membership is free' (
http://www.thecodecage.com)* & allows file
upload -faster and better answers
*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile:
http://www.thecodecage.com/forumz/member.php?userid=14
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=61118