+ Reply to Thread
Results 1 to 2 of 2

Lookup/sumif formula

  1. 08-24-2017, 06:35 AM #1
    Roma1r
    Roma1r is offline
    Registered User
    Join Date
    01-02-2014
    Location
    Cape Town
    MS-Off Ver
    Excel 2007
    Posts
    88

    Question Lookup/sumif formula

    Please see attachment - What is the best way to import from data sheet to collection sheet? pls help
    Many thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-24-2017, 07:35 AM #2
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Lookup/sumif formula

    Hi Roma1r- Paste this in C5 and copy down: 
    Please Login or Register  to view this content.
    I wasn't sure why you stopped at column E rather than M in your original formula, but I chose not to change it.
    Attached Files Attached Files
    Last edited by leelnich; 08-24-2017 at 07:42 AM.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    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. [SOLVED] H-Lookup/Sumif, Some sort of formula?
    By J_Norris in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-05-2015, 02:35 PM
  2. [SOLVED] Sumif or Sumifs formula to lookup Qty and sum them.
    By JESSHOR60 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2015, 03:59 AM
  3. Using a lookup & a sumif / countif in same formula
    By anthonykinsella1975 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2014, 09:45 AM
  4. Count formula, lookup or may sumif?
    By JapanDave in forum Excel General
    Replies: 2
    Last Post: 06-22-2009, 05:38 AM
  5. Lookup or SUMIF ??
    By rufusf in forum Excel General
    Replies: 2
    Last Post: 02-26-2009, 08:02 AM
  6. Help with lookup/sumif formula
    By rise.off in forum Excel General
    Replies: 1
    Last Post: 07-30-2008, 06:36 AM
  7. a formula using SUMIF or/and Lookup features
    By ExcelNewby in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2007, 08:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1