View Single Post
  #1   Report Post  
Jones
 
Posts: n/a
Default I Need to Count Number of Entries Based on Two Criteria

I need to count the number of entries in column B only if column J does not
equal "1" AND column B is 3.

Not looking for a "sum" or to "multiply", I simply need a count of the
number of entries in column B that match these two criteria.

I have tried combining functions through IF and COUNTIF, but have not been
successful. Any ideas? Thanks :)