Results 1 to 5 of 5

Getting Multiple Rows Total with Vlookup

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2010
    Posts
    77

    Getting Multiple Rows Total with Vlookup

    Hi,
    l find first variable from the table with vlookup formula and l bump with second variable. In this way, 15 lines continues one under. At the end, l take sum of the results.
    The following formula can do this process, but my other tables has more than 15 lines. Can we solve this with a short formula?

    =DÜŞEYARA(B3;$E$3:$F$23;2;0)*C3+DÜŞEYARA(B4;$E$3:$F$23;2;0)*C4+DÜŞEYARA(B5;$E$3:$F$23;2;0)*C5+DÜŞEYARA(B6;$E$3:$F$23;2;0)*C6+DÜŞEYARA(B7;$E$3:$F$23;2;0)*C7+DÜŞEYARA(B8;$E$3:$F$23;2;0)*C8+DÜŞEYARA(B9;$E$3:$F$23;2;0)*C9+DÜŞEYARA(B10;$E$3:$F$23;2;0)*C10+DÜŞEYARA(B11;$E$3:$F$23;2;0)*C11+DÜŞEYARA(B12;$E$3:$F$23;2;0)*C12+DÜŞEYARA(B13;$E$3:$F$23;2;0)*C13+DÜŞEYARA(B14;$E$3:$F$23;2;0)*C14+DÜŞEYARA(B15;$E$3:$F$23;2;0)*C15+DÜŞEYARA(B16;$E$3:$F$23;2;0)*C16+DÜŞEYARA(B17;$E$3:$F$23;2;0)*C17
    The sample file is attached.
    Regards.
    Sorry my language.
    Thank you for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 11-16-2011, 09:10 AM
  2. Multiple total rows for tables
    By RickDM in forum Excel General
    Replies: 1
    Last Post: 08-20-2011, 07:57 AM
  3. Reading multiple lines in a VLOOKUP to provide a total?
    By Injury Finger in forum Excel General
    Replies: 4
    Last Post: 03-22-2010, 11:17 AM
  4. Multiple ccolums/rows to get data from multiple columns/rows (vlookup)
    By Ramzes in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2010, 05:35 AM
  5. Total # of used rows in multiple spreadsheets?
    By JP Romano in forum Excel General
    Replies: 0
    Last Post: 08-24-2009, 09:03 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1