+ Reply to Thread
Results 1 to 5 of 5

Sumprod if time and weekday

  1. #1
    Forum Contributor alexxl's Avatar
    Join Date
    04-21-2015
    Location
    Romania
    MS-Off Ver
    2019/2010
    Posts
    305

    Sumprod if time and weekday

    Sumprod Cond.xlsx

    If condition inside file are met extract me the results in the yellow cell.


    Alex

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sumprod if time and weekday

    No values met your Sat/Sun criteria... I added ONE, so the excepcted answer becomes 17...

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Contributor alexxl's Avatar
    Join Date
    04-21-2015
    Location
    Romania
    MS-Off Ver
    2019/2010
    Posts
    305

    Re: Sumprod if time and weekday

    Thank you. This is what i was looking for!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Sumprod if time and weekday

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

  5. #5
    Forum Contributor alexxl's Avatar
    Join Date
    04-21-2015
    Location
    Romania
    MS-Off Ver
    2019/2010
    Posts
    305

    Re: Sumprod if time and weekday

    I can`t give you reputation anymore i have to spread it 2 someone else first !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2016 Weekday/Weekend with time
    By Oghenovo in forum Office 365
    Replies: 12
    Last Post: 07-28-2021, 02:45 PM
  2. Using weekday function to get average if criteria range equals weekday
    By andrew.beckett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-05-2020, 05:09 AM
  3. Wait until weekday time
    By astrikor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2019, 10:39 AM
  4. Excel VBA code to return weekday name from a date then autofilters for userdefined weekday
    By studyengineering in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2016, 03:24 PM
  5. finding the MIN and MAX values for weekday only job time
    By rde55cae in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-21-2015, 12:42 PM
  6. [SOLVED] Plot time against Weekday
    By kiele001 in forum Excel General
    Replies: 12
    Last Post: 04-26-2012, 05:20 AM
  7. Weekday Function (Time Card)
    By B. Baumgartner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-08-2005, 07:24 PM

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