+ Reply to Thread
Results 1 to 4 of 4

Sum multiple rows (SUMIF?)

  1. #1
    Registered User
    Join Date
    03-01-2006
    Posts
    32

    Sum multiple rows (SUMIF?)

    Attached zip has .xls file that explains my question. I have weekly sales figure for fruits sold in store. I need to generate total sales made between two given dates. I tried SUMIF but couldn't achieve what I wanted. How can I do that? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,071
    Hi,

    See attached ...
    Attached Files Attached Files
    HTH
    Carim


    Top Excel Links

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    To do that with a single formula......

    =SUM(IF(D6:Y6>=C12,IF(D6:Y6<=C13,IF( ISNUMBER(D7:Y10),D7:Y10))))

    confirmed with CTRL+SHIFT+ENTER

  4. #4
    Registered User
    Join Date
    03-01-2006
    Posts
    32
    thanks carim and daddy...

    Is there easy way to take care of pro-rata value for a week that is not completely falling within given start and end dates.

    What I ultimately want is to develop a VBA function that uses weekly data and returns me MONTHLY (pro-rata based) sum for all fruits.

+ 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