Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post

    Help with nesting Sumproduct and Countifs

    Hi All - I have two formulas (below) that work fine independently, however I need to embed these to return 1 result based on the two criteria. I've tried numerous combinations, but can't get them to work. So time to call on some expert assistance.


    =SUMPRODUCT((WEEKDAY('Rec inj and cat 3 above import'!$I$8:$I$1000)=1)*1)

    =COUNTIFS('Rec inj and cat 3 above import'!K8:K2000,A98)

    Any assistance would be much appreciated.

    Regards

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    In what cell is the result of the sumproduct?

    Not quite sure what you're trying to count.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Perth, Western Australia, Australia
    Posts
    487
    Thanks
    75
    Thanked 2 Times in 1 Post
    Hi Thanks for the reply

    I'm trying to count the number of dates that are a Sunday (1) (in this case) in !$I$8:$I$1000 that meet the criteria at A98 in the countifs.

    Hope that hepls

    Regards

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    What about:

    =SUMPRODUCT((A98='Rec inj and cat 3 above import'!K8:K2000)*(WEEKDAY('Rec inj and cat 3 above import'!$I$8:$I$2000)=1))

    [need the same number of cells in the range]
    Last edited by kweaver; 2015-05-08 at 02:28.

  5. The Following User Says Thank You to kweaver For This Useful Post:

    verada (2015-05-08)

Posting Permissions

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