COUNTIFS help

[RussChilds]

Hi Everyone,

I'm using the following formula for working out Students who are above target and it works great.

=COUNTIFS($T:$T,">0",G:G,"RE Class 1")/D13

I want to also add to that formula (but I can't get it to work) to only include students "column H:H" with an attendance greater than "95%"

Can you help?

Many thanks,
Russ

 

[jasonb75]

Try

=COUNTIFS($T:$T,">0",G:G,"RE Class 1",H:H,">"&0.95)/D13

change ">" to ">=" if needed.

 

[RussChilds]

Perfect! Thant works. Cheers Jason!!