+ Reply to Thread
Results 1 to 4 of 4

Sumif or double vlookup and then sum, lookup name then account # then sum price

  1. 02-13-2014, 02:40 PM #1
    HC1994
    HC1994 is offline
    Registered User
    Join Date
    02-04-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    48

    Exclamation Sumif or double vlookup and then sum, lookup name then account # then sum price

    Hi guys,

    Please see my attached Excel sheet for reference. example.xlsx

    I am trying to sum the amount with the same employee name and same account number. It should look like something in the K, L, M. It's pretty much using two Vlookup and summing it... I don't think Sumif could work? Please let me know!!! ><
    Last edited by HC1994; 02-13-2014 at 02:42 PM.
    Reply With QuoteRegister To Reply
  2. 02-13-2014, 02:44 PM #2
    Moo the Dog
    Moo the Dog is offline
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Sumif or double vlookup and then sum, lookup name then account # then sum price

    You could use SUMIFS:

    =SUMIFS(C:C,A:A,K4,B:B,L4)

    - Moo
    Reply With QuoteRegister To Reply
  3. 02-13-2014, 03:08 PM #3
    HC1994
    HC1994 is offline
    Registered User
    Join Date
    02-04-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    48

    Re: Sumif or double vlookup and then sum, lookup name then account # then sum price

    Quote Originally Posted by moo the dog View Post
    you could use sumifs:

    =sumifs(c:c,a:a,k4,b:b,l4)

    - moo

    thanks sooo much! :d
    Reply With QuoteRegister To Reply
  4. 02-13-2014, 03:42 PM #4
    Moo the Dog
    Moo the Dog is offline
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Sumif or double vlookup and then sum, lookup name then account # then sum price

    Glad to help, and thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. vLOOKUP returning #NA until I double click in the lookup value cell
    By Riehl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-16-2018, 09:27 AM
  2. [SOLVED] Allocate total price by term taking account start and end date and month affected
    By continue101 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2013, 01:47 PM
  3. [SOLVED] Sumif of a range i.e between account codes 100 - 500
    By Hesh in forum Excel General
    Replies: 5
    Last Post: 06-18-2012, 07:10 AM
  4. Excel 2008 : lookup an account in a row
    By MARYGENEBU in forum Excel General
    Replies: 1
    Last Post: 01-10-2011, 10:43 AM
  5. Double lookup without using vlookup?
    By HBF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-17-2006, 06:02 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1