8 Replies Latest reply on Sep 26, 2018 10:07 AM by Deepak Rai

    New to CountIF

    Leif Hurst

      Coming from SQL I didn't do a lot of this so bare with me. I have 3 fields that I'm getting data for (CustId, InvId, and Item). I want to calculate the number of invoices as long as the Item contains the word "home" and take that as a percentage against all customers.

       

      Simply put, I'm trying to see the percentage of customers that had an invoice with the item "home." If the item "home" shows up 9 times, it should just be counted once.

       

      Where would I even get started with something like this?