Forum Discussion
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.
Is there a way to simplify it so its shorter and doesn't require editing:
=IFS(COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=0,"None",COUNT(J2,N2,L2,M2,#REF!,O2,P2,Q2)=1,"V1",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=2,"V2",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=3,"V3",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=4,"V4",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=5,"V5",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=6,"V6",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=6,"V6",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=7,"V7",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=8,"V8",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2,R2,S2)=9,"V9",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2,R2,S2)=10,"V10")
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")
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")
