Results 1 to 3 of 3

Thread: SUM Weekday formula ?

  1. #1

    SUM Weekday formula ?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    hello,

    I have to SUM working hours from each Monday to Sunday in the month. How can I do that ?

    Sample workshhet is attached !

    Thanks for help !

    regards, Luka
    Attached Files Attached Files

  2. #2
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    190
    Articles
    0
    Excel Version
    Version 2002 Build 12527.20194
    how do you want the sum's reported?

    if you put this in cell a3, and copy right. it will report the sum for the week.

    =IF(WEEKDAY(A1)=2,SUM(B2:OFFSET(A2,0,7,)),"")

  3. #3
    I works, thanks you !

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •