+ Reply to Thread
Results 1 to 4 of 4

How to SUM IF this?

Hybrid View

  1. 02-25-2016, 06:52 PM #1
    toci
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Lightbulb How to SUM IF this?

    Hello,

    Can someone help me with this SUM.
    So, in Column B1 I have Date and based on that Date I need to define the Week and to calculate SUM for that Week.
    Week range is SAT-FRI.
    C1,D1,E1 I used to define the Week to get the same name like in H1:P1 as I don't know another way.

    Thank you All.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-25-2016, 06:59 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: How to SUM IF this?

    Try it this way:

    =SUMPRODUCT((H1:P1=E1)*H2:P4)
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 02-25-2016, 07:31 PM #3
    toci
    toci is offline
    Forum Contributor
    Join Date
    11-03-2014
    Location
    Belgrade
    MS-Off Ver
    2010
    Posts
    348

    Re: How to SUM IF this?

    Cheers ConneXionLost.....
    Once more question regarding this.
    Is it possible to define Week in format e.g "Week 6" just on Date from cell B1?
    Reply With QuoteRegister To Reply
  4. 02-25-2016, 10:57 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2405
    Posts
    13,430

    Re: How to SUM IF this?

    Try this adjustment to C X L's formula

    =SUMPRODUCT((H1:P1="Week "&WEEKNUM(B1))*H2:P4)
    Dave
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1