COUNTIF with AND Statement

Cory Garner

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

Genevieve P.

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