If I have a two columns, Column A is the company number and Column B is the group number. Is there a way in excel to bring up the members of a group? I want to have a list of all company number within the group 400 to run vlookups to calculate the total profit for each and compare it to the total to ensure no new facilities have been added.
A B
100 500
101 400
102 500
103 400
104 500
105 300
106 300
EDIT:
The SUMPRODUCT() formula can do this:
=SUMPRODUCT(--($A$1:$A$100=100), --($B$1:$B$100=400), $C$1:$C$100)
Last edited by JBeaucaire; 11-10-2010 at 08:46 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
assuming you want to do more than a simple sumif then with a helper column(even then sumproduct may do what you want)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks