I am having an issue with a formula in excel and am not understanding what it is doing

=COUNTIF(J28:L31,"w")+COUNTIF(J28:L31,"l")

is supposed to give me a result of the number of cells with the value of either w or l in that range

But instead of displaying a number, it is displaying the formula.

can anyone tell me what it is that I'm doing wrong?

thanks
douglas

It may be a syntax error. Please check your full code.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.