I have a spread sheet and I'm trying to sumproduct "Female" from Column B7:B40 and then to countif exam grades A* through to C grades on columns C7:C40. I've tried the following: =SUMPRODUCT(B7:B40="F")+COUNTIF(C7:C40;"A#")+COUNTIF(C7:C40;"A") But this returns either a Value or a different incorrect number.

Can anyone help please?

Thanks
Jorge666