Concatenating a row number to a column letter

[DashboardNovice]

I am trying to create the following formula:

COUNTIF(H18:H32,"W")

To do this I am calculating the '32' then I am trying to concatenate the '32' to what comes before. The current value in C10 is 15.

Here is what I have. Why is this not working?

=COUNTIF(H18:H&C10+17,"W")

 

[NARAYANK991]

Hi ,

Try this :

=COUNTIF(INDIRECT("H18:H" & (C10 + 17)), "W")

Narayan

 

[DashboardNovice]

Hi ,

Try this :

=COUNTIF(INDIRECT("H18:H" & (C10 + 17)), "W")

Narayan

Great. It worked. Thank you sir.