COUNTIF with AND Statement

Is someone able to help? I cannot figure this out.
The "working sheet" is where I'm inputting the formula.
I want to count if the form was received and by FBC.
REFERENCE SHEET
WORKING SHEET
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
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!