=SUMIFS(B2:B6,A2:A6,"=J*")
Please note J* = Starting letter J
Like than u can change R* and P*
ceab wrote:
Conditional addition of cells
19-Feb-08
I want to add the sales (column B) of the people in column A
A
James 2
Randy 4
Paul 1
James 4
Paul 5
....and get this result
C
James 6
Randy 4
Paul 6
Only the result in column D needs to be calculated
Any help much appreciated.
Previous Posts In This Thread:
Conditional addition of cells
I want to add the sales (column B) of the people in column A
A
James 2
Randy 4
Paul 1
James 4
Paul 5
....and get this result
C
James 6
Randy 4
Paul 6
Only the result in column D needs to be calculated
Any help much appreciated.
Re: Conditional addition of cells
Since you state that
"Only the result in column D needs to be calculated
I'll assume that you have already entered the list of unique names in Column
C
So, in D1 enter this
=Sumif(A$1:A$5,C1,B$1:B$5
And copy down
--
HTH
R
--------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit
--------------------------------------------------------------------------
Thanks for the hint.
Thanks for the hint
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5)
You're welcome. and appreciate the feed-back.
You're welcome. and appreciate the feed-back
--
Regards
R
----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit
----------------------------------------------------------------------------------------------
Thanks for the hint
I got it working like this =Sumif(A$1:A$5;C1;B$1:B$5
"RagDyer" <
[email protected]> kirjoitt
viestiss?:%
[email protected]...
Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Selected Text Favorites Utility for your Web Site
http://www.eggheadcafe.com/tutorial...c-86feb39cae83/build-a-selected-text-fav.aspx