Count the first x number of cells

[Rote Rose]

Hello!

I try to count the number of "x" in the first 98 cells I11 to FG11 (the number of cells in the raw is variabel which is linked in cell FM7).

I used this formula:

=COUNTIF(I11:FG11,"x")-IF(COUNT(I11:FG11)>FM7,COUNTIF(INDEX(I11:FG11,COUNT(I11:FG11)-FK7),"x"),0)

this formula counts for all cells and doesn't stop after 98 cells.

Can you please tell me what's the wrong or if you have a better one?

Thanks a lot

 

[jasonb75]

Welcome to the board!

Try

=COUNTIF(I11:INDEX(I11:FG11,FM7),"x")

 

[Rote Rose]

Hi Jasonb75,

thanks for your help. I think my problem is that I use a spreadsheet of google docs so the formula doesn't work for me. I thought that this should be the same like excel. I get the error: "unknown name range I11". The spreadsheet has a problem with the first I11 in your formula =COUNTIF(I11:INDEX(I11:FG11,FM7),"x").

Is there a possibility to add something in order for the I11 to be known as a cell?

Thanks again

 

[jasonb75]

I'm not familiar with google docs but would suspect that the problem is not I11 but the index funciton appended to it.

Try

=countif(offset(I11,0,0,0,FM7),"x")

 

[Rote Rose]

Thanks a lot!!! It works