Countifs with multiple ranges and criteria

[tabbytomo]

Hi, I'm trying to do a countifs, that will count the number of cells with the criteria 'Adults' in column A, that have one of the following criteria in column B; 'Active assignment', 'secondment', 'acting up'.

I'm writing the following but recieving a circular error:
=COUNTIFS(Fire!$F:$F,"826 Adult Services L4 ",$M:$M,"Active Assignment")+COUNTIFS(Fire!$F:$F,"826 Adult Services L4 ",$M:$M,"Acting Up")+COUNTIFS(Fire!$F:$F,"826 Adult Services L4 ",$M:$M,"Internal Secondment")

Then i'd like to do another countifs, that will be the same as the above, with the added critera of 'date greater than '01/01/2015', in column C.

I'm writing the following, but it's not pulling the correct amount:
=COUNTIFS(Fire!$F:$F,{"826 Adult Services L4 "},Fire!$M:$M,{"Active Assignment","Acting Up","Internal Secondment"},Fire!$R:$R,{">10/07/2015"})

Any help truly appreciated!

 

[steve the fish]

Wrap it in a SUM:

=SUM(COUNTIFS(Fire!$F:$F,"826 Adult Services L4 ",Fire!$M:$M,{"Active Assignment","Acting Up","Internal Secondment"},Fire!$R:$R,">10/07/2015"))

 

[tabbytomo]

That's beautiful, works dead easy! Thank you so much!