Hi Guys,
Bit of an newbie here so here goes!
I have attached a sample spreadsheet which has Cable Types in Column A and Cable Length of said cable in Column B.
What I would like is to have a formula that will search Column A for the cable types get the corresponding length in Column B and sub-total them together in the red cells
I was thinking some sort of VLookup but cannot seem to get it quite right
Any suggestions would be appreciated!
=sumif($a$2:$a$15,a19,$b$2:$b$15)
=sumif($a$2:$a$15,a20,$b$2:$b$15)
=sumif($a$2:$a$15,a21,$b$2:$b$15)
in B19
=SUMIF(A$2:A$15,A19,B$2:B$15)
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks a million guys cant believe i spent so much time on the VLOOKUP Thanks again much appreciated.
Or with a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks