COUNTIF or COUNTIFS

[Svein Tore Kristensen]

Hello

I have this - but it is wrong.

=COUNTIF(CW6:CW75;"A")

I have in addition a column CV where it is a number.
Column CW have several A, but I want criterion to only include
A where column "CV" contain a number and that must contain a number (1,2 or 3).
Then it must be summed only "A" in CW (times with number in CV) only if there is number in CV.

Maybe COUNTIFS is right but I can't that
Is there someone who can help me?
Thank you in advance

[#2]

@Svein Tore Kristensen 

That could be like

=SUM(COUNTIFS(CW6:CW75,"A",CV6:CV75,{1,2,3}))

Only change , on ; for your locale, not sure about function names.

[#3]

@Sergei Baklan 

thanks for reply.
Sorry, it didn't work. marks errors

[#4]

@Svein Tore Kristensen 

Please check in attached file

[#5]

Thanks @Sergei Baklan 

thanks for reply.
Yes, it worked !! :) NICE!!! :)
However, in cases where it refers to 2 or 3, only 1 is counted

See Attached file

takes evening, checks tomorrow

[#6]

@Svein Tore Kristensen 

Sorry, didn't catch what exactly do you mean. Could you please add to your file formula in question?