• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. D

    Countifs for Unique Values

    Debraj, You're my hero! Thank you so much :) Until next time, Dmitry
  2. D

    Countifs for Unique Values

    Hi All, I have a minor tweak to the original problem here, and I'm having trouble executing it. I need to input one additional layer into the "CountIf", or rather one additional condition on which to count from. Still need to find total UNIQUE fruit, by family, ">0", but now I want to...
  3. D

    Countifs for Unique Values

    You guys are AMAZING. Thank you so much!!
  4. D

    Countifs for Unique Values

    Thank you so much Debraj! I have one additional question. I'm trying to perform this function in a different place, and for dozens of different "families". How would you embed the INDEX function into this formula so that I could call it out on multiple tabs automatically? I provided an example...
  5. D

    Countifs for Unique Values

    I'm trying to perform a total count of unique cells based on multiple criteria/conditions. I've outlined a scenario on the spreadsheet linked below, as well as what the outcomes SHOULD be. I just need the formula. I think it should involve the sum(if(frequency(match functions, but I can't seem...
Back
Top