+ Reply to Thread
Results 1 to 5 of 5

Looking for an efficient way to sum

  1. #1
    Registered User
    Join Date
    03-15-2021
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    17

    Question Looking for an efficient way to sum

    Book3.xlsx

    In the attached file I have two sheets: one with two columns for store numbers and their loss, another with "table" indicating which Area Managers have which stores.

    I want to write a formula that will add up the loss for all stores an area manager has. I can think of a couple of ways, but they seem a bit messy:
    • sum of Vlookups
    • rework the stores and AM list and then do a SumIf

    Can anyone suggest a cleaner/more efficient way?
    Last edited by Bartholomeu; 06-13-2024 at 04:46 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,848

    Re: Looking for an efficient way to sum

    Try

    in H3 and copy down

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    6,046

    Re: Looking for an efficient way to sum

    Try this in H3:

    =SUM(SUMIF(Stores!$A$3:$A$61,C3:G3,Stores!$B$3:$B$61))

  4. #4
    Registered User
    Join Date
    03-15-2021
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    17

    Re: Looking for an efficient way to sum

    Great! Thanks! I wasn't familiar with SUMPRODUCT. I'll have to read up on it. :-)

  5. #5
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    640

    Re: Looking for an efficient way to sum

    An alternative:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. More efficient COUNTIF?
    By WowImMatt in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 01-21-2022, 05:31 AM
  2. VBA more efficient
    By benoj2005 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-27-2021, 12:40 AM
  3. More Efficient Code
    By saechaoc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2015, 03:29 PM
  4. Matching string in an array of strings
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 05:54 PM
  5. Wondering if theres a more efficient way besides For Each to...
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-28-2012, 12:39 PM
  6. more efficient VBA?
    By markx in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-07-2006, 12:45 PM
  7. [SOLVED] Is there a more efficient way to do this?
    By Steve Roberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 01:05 PM

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