Countif with multiple criteria

Krystab352

I am trying to create a countif formula with multiple criteria with one being the approval status and the other being scheduled (which is a date and I want to count it as "1"). 

I'm trying =countifs(range1, "Approved") +countif(range 2, ???) 

The question marks if where I am having issues. The column is formatting as a date not text/number so that may be the issue. I tried =countifs(range1, "Approved") +countif(range 2, NOT(ISBLANK(@cell)) and it returned a wrong number.

Any suggestions? I'm getting really frustrated.

Nic Larsen

Try this format. Just update my formula for your range names. 

=COUNTIFS(date:date, NOT(ISBLANK(@cell)), [range1]:[range1], ="Approved")

Metric Momma

What am I doing wrong? I'm trying to count how many projects each team member is working on but I need the status of their project assignments to be In Process. I'm using this for a metrics table so I'm referencing a different report for source data.

This one is IMPARSEABLE

=IF({Product Bible Project Status}, "In Process"), COUNTIF([Primary Column]@row))

This one is INCORRECT ARGUMENT

=COUNTIF([Primary Column]@row, {Product Bible Project Status}, "In Process")

This one returns 0 and that's not correct

=COUNTIF([Primary Column]@row, {Product Bible Project Status} = "In Process")

Paul Newcome

@Metric Momma What are you wanting to compare to the [Primary Column]@row? Proper syntax is going to be

=COUNTIFS({Range 1}, Criteria 1, {Range 2}, Criteria 2)