I need help on a formula to sum in one column when a certain condition is met in another column. Here's the example:
A B
95275 2
95389 7
96752 5
95275 3
The correct response would be 95275=5, 95389=7, 96752=5. I can't use a table because the number in column B is not fixed, so the formula has to be able to differentiate between the number is column A and add the totals in column B. Any help is appreciated. Thanks.
Last edited by cpope; 02-22-2010 at 01:57 PM.
Pardon ?The correct response would be 95275=5, 95389=7, 96752=5
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
The return of the correct formula would show 95275 totaling 5 since it appears twice in column A (2+3).
Why not take a look at the advanced filter function to get a unique list and then use Sumif
=SUMIF(A2:A5,E2,B2:B5)
http://www.contextures.com/xladvfilter01.html#FilterUR
Thanks, works like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks