Results 1 to 3 of 3

Thread: Alternatives SUMPRODUCT ISO

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-23-2016, 05:07 PM #1
    PcMax
    PcMax is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel 2010 Unique Count in Pivot Tables with Helper Cells/Columns and Sumproduct
    By Tony_Caliente in forum Excel Help
    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. Sumproduct Formula To Sum Range With Criteria On Numeric Text
    By Howardc in forum Excel Help
    Replies: 11
    Last Post: 04-07-2013, 07:51 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
  •  

Forum Rules