Complex count if ?!

Originally Posted by daddylonglegs

Try SUMPRODUCT like this

=SUMPRODUCT((B2:B94=1)*(A2:A94="FA"))

Note: I took out the quotes around the 1 - probably not needed if column B data is numeric

Thats fantastic exactly what i was looking for 5* for you