thank you


1) Gives me a message error *NOM?

Sub Demo()
A = 1: B = 2: C = 3: d = 4: E = 5
F = 6: G = 7: H = 8: I = 9: J = 10

v = Array(A, B, C, d, E, F, G, H, I, J)
[A1] = [SumProduct(-(v=1), -(v<=5))]
End Sub


2) work but is very slow, is it normal

.Names.Add Name:="ArrTemp", RefersToR1C1:=Array(A, B, C, D, E, F, G, H, I,
J)


Dana DeLouis a écrit :
Remember... TRUE in vba is Backwards. :0

Sub Demo()
A = 1: B = 2: C = 3: d = 4: E = 5
F = 6: G = 7: H = 8: I = 9: J = 10

v = Array(A, B, C, d, E, F, G, H, I, J)
[A1] = [SumProduct(-(v=1), -(v<=5))]
End Sub