COUNTIF with AND Statement
Answers
-
Hi Cory,
It sounds like you just need a COUNTIFS function (with an S at the end to indicate multiple criteria). Try this:
=COUNTIFS({Form Received Column}, 1, {FBC Column}, FBC@row)
The ranges {in these} are cross-sheet references to your Reference Sheet. The first 1 indicates that you're looking for a check in the box, and the second criteria listed, FBC@row, means you're looking for the FBC type that's in that current row... for example, AC.
You can then drag-fill this formula down your completed column for the Count.
Let me know if you have any questions about this!
Cheers,
Genevieve
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!