+ Reply to Thread
Results 1 to 4 of 4

Sum and lookup

Hybrid View

gvelix Sum and lookup 02-18-2008, 12:01 PM
EdMac Hi For example in I2 ... 02-18-2008, 12:54 PM
gvelix Thanks a lot!!, It worked... 02-18-2008, 02:20 PM
EdMac You're welcome. thanks for... 02-18-2008, 02:34 PM
  1. #1
    Registered User
    Join Date
    02-06-2008
    Posts
    10

    Sum and lookup

    Hello, I need a little of help

    I need to sum the value of a colum for every pack of years. The problem is that in some cases I got 28 rows for a year and in other cases more or less..So I suppose that the formula should sum when the year changes, but I dont know how to do this...

    I have attached an example (the original has like 50000 rows)

    Your help would be greatly appreciated!!
    Attached Files Attached Files

  2. #2
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    Hi

    For example in I2

    =SUMPRODUCT(--(A2:A56=L2)*(B2:B56=G2),(D2:D56))
    Will give Argentina and 1980 total

    Ed

  3. #3
    Registered User
    Join Date
    02-06-2008
    Posts
    10
    Thanks a lot!!, It worked very well!

  4. #4
    Forum Contributor EdMac's Avatar
    Join Date
    01-23-2006
    Location
    Exeter, UK
    MS-Off Ver
    2003
    Posts
    1,264
    You're welcome.

    thanks for the feedback

    Ed

+ 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