Sumproduct if cell value = "J"

[neodjandre]

I am using this formula which works but I want to change the part ISTEXT($E$9:$E$297), to IF Cell Value = "J"... Can't figure it out

SUMPRODUCT(--ISTEXT($E$9:$E$297),--ISNUMBER(K$9:K$297))

many thanks,
Andrew

 

[wideboydixon]

=sumproduct(($e$9:$e$297="j")*(isnumber(k$9:k$297)))

wbd

 

[AhoyNC]

Maybe:
SUMPRODUCT(--($E$9:$E$297="J"),--ISNUMBER(K$9:K$297))

 

[neodjandre]

=sumproduct(($e$9:$e$297="j")*(isnumber(k$9:k$297)))

wbd

great