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
    187
    Articles
    0
    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
  •