I am trying ti look up and match info from 2 columns, from this add the numbers together in a third column and placing the answer in a cell
example data
Line Group Qty
1 77 10
1 55 20
2 88 10
2 66 20
2 88 32
2 66 57
2 88 28
3 88 15
3 66 20
3 88 10
3 66 20
4 88 15
4 66 25
so what i need is from line 2 group 88 = total 70 thanks in advance
try:
=sumifs(c:c, a:a, 2, b:b, 88)
where c:c is QTY, a:a is Line and b:b is Group.
if the values 2 and 88 are coming from some two cells, you can replace them with their respective cell addresses in the above.
Last edited by icestationzbra; 09-11-2012 at 10:30 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Hi icestationzebra, this came up with error
=SUMIFS($A$3:$A$282,A4,$B$3:$B$282,A14,$E$3:$E$282)
A4 = Line, A14 = Group
Last edited by t16732; 09-11-2012 at 11:02 PM.
try:
=SUMIFS($E$3:$E$282,$A$3:$A$282,2,$B$3:$B$282,88)
icestationzbra, thankyou for your help, this has worked, and other colleges thankyou also as it has helped on many tasks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks