SOLVED

Problems whit the function Count.If for correlatives

Copper Contributor

Hi, i have a problem whit this function..... i have a table and in the first column i want a correlative that count the number of times that a cod_id exist in another column but in the specific row that im working.... so i used this function:

 

image.png

 

but when i add another cod_id and the table create the new row the funcion have a automatic change.image.png

the c10 must to be c9 but it changed automaticly.... please Help!!!!!

4 Replies
best response confirmed by Diego Armando Segovia Guatemala (Copper Contributor)
Solution

Diego,

 

there is a bug with expanding ranges.

 

Running Total in a Microsoft Excel Table

Thanks for answer, and dont you know how can i do that correlative, maybe whit another function en VBA or a sub.

Just check the video and the link.

 

Thanks, i was frustrated whit this problem, but the link works very well!!!
1 best response

Accepted Solutions
best response confirmed by Diego Armando Segovia Guatemala (Copper Contributor)