Forum Discussion

LauraDaisy's avatar
LauraDaisy
Copper Contributor
Apr 15, 2024
Solved

Count - simplified for added columns

I created a count formula for uploaded date to give a version number but we add columns as more edits are made.    I am currently adding a new section to the formula when we add a new column.   I...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Apr 15, 2024

    LauraDaisy don't understand why you would address every single cell in a closed range. And you have duplications in there as well. Is that intended?

     

    I you just want to count the number of numeric entries in a range and add the letter "V" in the beginning use:

     

     

    ="V"&COUNT(J2,L2:Z2)

     

     

    and make the range L2:Z2 large enough so that you can enter more versions later on. "V0" would mean "None".

    If returning "None" is important, than you could use this:

     

    =IF(COUNT(J2,L2:Z2),"V"&COUNT(J2,L2:Z2),"None")

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 15, 2024

LauraDaisy don't understand why you would address every single cell in a closed range. And you have duplications in there as well. Is that intended?

 

I you just want to count the number of numeric entries in a range and add the letter "V" in the beginning use:

 

 

="V"&COUNT(J2,L2:Z2)

 

 

and make the range L2:Z2 large enough so that you can enter more versions later on. "V0" would mean "None".

If returning "None" is important, than you could use this:

 

=IF(COUNT(J2,L2:Z2),"V"&COUNT(J2,L2:Z2),"None")

 

Resources