LinkBack URL
About LinkBacks
I have range like
a
b
c
d
and a table
a 1
b 2
d 3
g 5
h 7
and where the range and table correspond
I need to add the second column together
in the example it'd equal 6
What's the easiest solution for this?
I have range like
a
b
c
d
and a table
a 1
b 2
d 3
g 5
h 7
and where the range and table correspond
I need to add the second column together
in the example it'd equal 6
What's the easiest solution for this?
Hi g1eagle,
Welcome to the forum.
Try using below formula:-
Formula:
Please Login or Register to view this content.
See attached:- range equals then sum next column.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
Removing is a number and making the smallest of the ranges the second one, works beautifully. Thanks for the help
is your query resolved ?
regards,
DILIPandey
<click on below 'star' if this helps>
yes it is, it's why I marked the thread solved... was I supposed to do something else that I missed?
No .. that's fine.. Thanks.
regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks