Results 1 to 3 of 3

Thread: Alternatives SUMPRODUCT ISO

  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    13

    Alternatives SUMPRODUCT ISO

    I created a formula for a search of the current week, I ask if there are alternatives

    Code:
    =SUMPRODUCT((YEAR($C$3:$AAC$3)=YEAR($B$14))*(ISOWEEKNUM($B$14)=$B$15)*(C4:AAC4="K"))
    Thank you for your cooperation
    Attached Files Attached Files

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    12
    =weeknum(today();21)

    or
    Code:
    Function F_ISOweeknumber(d_01)
      F_ISOweeknumber=Format("ww",d_01-WeekDay(d_01,2)+4,2,2)
    End Function

  3. #3
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    13
    thank you snb

    I used the formula
    Code:
    =weeknum(today();21)
    Test Ok

    Code:
    Otherwise the function:
    Function F_ISOweeknumber(d_01)
      F_ISOweeknumber=Format("ww",d_01-WeekDay(d_01,2)+4,2,2)
    End Function
    I could not use it, I think for local language problems

    I successfully tested
    Code:
    Public Function fSettimana(ByVal v As Variant) As Long
        Application.Volatile
        fSettimana = Format(DatePart("ww", v, , 0), "ww", vbMonday, vbFirstJan1)
    End Function
    I was looking for the formula I modified in this way:
    =COUNTIF(OFFSET(TURNI!$A$4:$A$9,0,MATCH(B14,TURNI! $A$3:$ZZ$3,0)-WEEKDAY(B14,2),100,7),"K")
    Total count voices of the week
    Attached Files Attached Files

Similar Threads

  1. Replies: 1
    Last Post: 03-08-2016, 06:30 PM
  2. Sumproduct and Sumif in vba in large datasheet
    By Jean72 in forum Excel Help
    Replies: 1
    Last Post: 02-08-2016, 07:41 PM
  3. SUMPRODUCT function with heaps of IFS
    By Opsintern in forum Excel Help
    Replies: 3
    Last Post: 07-03-2015, 08:37 AM
  4. Replies: 11
    Last Post: 04-07-2013, 07:51 PM

Posting Permissions

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