+ Reply to Thread
Results 1 to 1 of 1

Sum-up all quantity of products in Total sheet

  1. #1
    Registered User
    Join Date
    04-04-2011
    Location
    Oslo
    MS-Off Ver
    Excel 2007
    Posts
    21

    Sum-up all quantity of products in Total sheet

    Hi. I want to get total of different products in Total-sheet ?
    I have a file with 11 worksheets. A:A contains product numbers (they are in different orders) & in E:E are quantity. My question is how to find matched product number & add its quantity in TOTAL-sheet?
    I have tried =SUMIF($A:$A;'Omr. 1'!$A:$A;'Omr. 1'!$E:$E)+=SUMIF($A:$A;'Omr. 2'!$A:$A;'Omr. 2'!$E:$E)
    But it does not work.
    I shall be very thankful if some one helps me out.
    regards
    /naghman
    Attached Images Attached Images
    Last edited by Naghman; 04-05-2011 at 01:48 AM. Reason: wrong title

+ 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