count functions

[ronniesteel]

Hi, I want to count a row of cells, but I only want to count them when another row of cells have numbers in them.

I've tried this but I don't get the result I want. =COUNTIFS(Medal!$E$19:$Z$19,"<>"&"*",Medal!$E$7:$Z$7,"<>"&"*")

Any help would be nice.

Thanks

[#2 · Accepted solution]

@ronniesteel 

As variant

=SUMPRODUCT( (LEN(Medal!$E$19:$Z$19)>0)*(LEN(Medal!$E$7:$Z$7)>0))

[#3]

@Sergei Baklan 

Thanks for your help.

Works great. 

Cheers,

Ronnie.

[#4]

@ronniesteel 

Ronnie, you are welcome