Sumifs or countifs and what is the formula


I have 3 columns of data:

  • Column 1 is a location (for example 101, 102, 201, 202)
  • Column 2 is a date (for example 12/1/2023, 12/2/2023)
  • Column 3 is a duplicate transaction labeled as D or if not a duplicate it is blank

Based on the location of 101, I want to see how many transactions occurred on 12/1/2023, and are not a duplicate.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!