how do i do a formula to count two different variables?

Jade · 04/05/23

Hi, I am trying to create a formula that will give me a count if two different variables are true:

I have 2 different columns 'Resource' & 'Status' I need to pull data that will portray how many jobs a person has when the status is 'in studio'

i.e for 'k' should read 1 as it's in studio but for 'j' it should read 0

Paul Newcome · 04/05/23

You would need a COUNTIFS.

=COUNTIFS(range 1, criteria 1, range 2, criteria 2)

Paul Newcome · 04/05/23

You would need a COUNTIFS.

=COUNTIFS(range 1, criteria 1, range 2, criteria 2)

Best Answer