Count Formulaes x 5

[midfieldgeneral11]

Good Morning

Can you help.

I have a skills matrix which I have designed which is completed by users.

They have options they can select 4, 3, 2, 1, 0 and what I want is to count the number skills that we have with the team in a total by these values.

To count from B1 to K1 the formulated formulas could provide help:

Count the number of 4s which are in the range of B1 to K1.

Count the number of 4 and 3 which are in the range of B1 to K1.

Count the number of 4, 3 and 2 which are in the range of B1 to K1.

Count the number of 4, 3, 2 and 1 which are in the range of B1 to K1.

Count the number of 4, 3, 2, 1 and 0 which are in the range of B1 to K1. (So everything?)

Could you provide help and assistance on the formulaes which combine count of multiple values

Thanks

MF11

 

[pgc01]

Hi

For ex:

=SUM(COUNTIF(B1:K1,{2,3,4}))

 

[midfieldgeneral11]

Apologies for the delay thanks very much worked like a:treat.