Relevant answer
F2=SUMPRODUCT(($B$1:$B$20=E2)*(MATCH($A$1:$A$20&$B$1:$B$20,$A$1:$A$20&$B$1:$B$20,)=ROW($B$1:$B$20))*1)
Relevant answer
I put wrong row number in previous reply, should be
CF Range =$A$3:$K$14
CF Formula =COUNT($D3:$J3)>1
Relevant answer
You say: "I get a prompt that something is wrong" ... what does the prompt say? Also, show your definitions of the names created in the Name Manager.
Relevant answer
Yo lo haría de la siguiente manera
Declare @query VARCHAR(MAX), @b VARCHAR (MAX) ,@cantidad Int
Set @b=‘Articulos’ Set @query=‘SELECT’+@cantidad+’=count(*) from’+b+’where costo>=1000’
Exec(@query)
If (@cantidad>10) begin SELECT ‘si jalo’ as funciona End
Relevant answer
Counts: =COUNT(IFERROR(MID(D8:D13,SEQUENCE(LEN(D8:D13)),3)/1,""))
Sum: =SUM(IFERROR(MID(D8:D13,SEQUENCE(LEN(D8:D13)),3)/1,0))
Relevant answer
Instead of -8 for the height, try -7. The height is not an offset from the referenced cell after applying the row/column offset arguments (whatever cell is referenced after apply row/column offset gets included in the range that results from applying height/width).
Relevant answer
Reviewing your rules and applying your original formula if someone gets FIVE 1s and ONE 6, they score a DISTINCTION, however should they get ONE 7, in place of the 6, they would receive a REFERRED. Is this correct?
Relevant answer
Zvi Twersky can you edit the query with a screenshot please, also have you tried using FIND() ?