Trying to use a count ifs formula.
its to count the number of A - C grades in one column, but it keeps returning a value of 0.
can anybody see where i might be going wrong? or suggest an alternative to countifs ?
It's not pretty but won't this do the job?
Either that or insert a Pivot table which will count everything up for you.
Thanks Guys, it may be messy but it works :)