+ Reply to Thread
Results 1 to 2 of 2

Alternative to sumifs for large sheet

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    61

    Alternative to sumifs for large sheet

    Hey All

    My excel

    Sheet 1Sheet 2

    A B A B
    Banana 1 Banana "sum"
    Banana 2 Apple
    Apple 3
    Orange 5
    ..... xx

    My problem: I need to sum the value in B based on the values in A. Ex banana should equal 3.

    I used sumifs/sumif and it works perfectly, but do to the fact that i have +30.000 rows makes it very slow to update

    Is it possible to use index match or sumproduct? Anyway i cant make either work.

    I hope theres help out there

    Thx in advance

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Alternative to sumifs for large sheet

    It can be done with an pivot table.
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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