Adding increment of 1

[Damian37]

Hello everyone,
I have a document that is a job tracker in which different people can go in to in order to add suggestions to the tracker. I would like to leave the initial A column blank until data is entered into any of the cells within the range of B:L. Currently I have added A1+1 within cell A2, but I would like to create a formula that would leave the A column blank until data is entered in to a new row within any of the cells in range B:L, and then add 1 to the number identified in the previous row within column A. Any help would be greatly appreciated. Thanks!!!

D.

 

[Michael M]

Maybe this in A2 and copy down

=IF(count(B2:L2,"")=0,"",A1 + 1)

 

[Damian37]

Maybe this in A2 and copy down

=IF(count(B2:L2,"")=0,"",A1 + 1)

Thank you Michael, I tried the formula, but unfortunately the formula just leaves the A column blank even though there is data within the range of B3:L3. Not entirely sure what I might be doing wrong. Here is the formula I used:

=if(count(B3:L3, "")=0,"",A2 + 1)

Thanks!
D.

 

[Michael M]

Ok, use this.
I assumed the B:L was numeric...

=IF(COUNTA(B3:L3, "")=0,"",A2 + 1)

 

[jtakw]

Hi,

I think Michael meant to use COUNTIF:

=IF(COUNTIF(B2:L2,"<>"),A1+1,"")

 

[Michael M]

@jtakw

No....I was happy with countA...

 

[jtakw]

Ok, Michael, Great.

The reason I thought you meant COUNTIF is because of the extra "criteria" in your formula:

=IF(COUNTA(B3:L3, "")=0,"",A2 + 1)

which will error out, and always result in FALSE

So maybe you meant this:

=IF(COUNTA(B2:L2),A1+1,"")

or this:

=IF(COUNTA(B2:L2)=0,"",A1+1)

 

[Michael M]

yep, your right....

=IF(COUNTA(B2:L2)=0,"",A1+1)

 

[Damian37]

Ok, Michael, Great.

The reason I thought you meant COUNTIF is because of the extra "criteria" in your formula:



which will error out, and always result in FALSE

So maybe you meant this:

=IF(COUNTA(B2:L2),A1+1,"")

or this:

=IF(COUNTA(B2:L2)=0,"",A1+1)

Hi jtakw,
I attempted the formula you submitted to Michael M, but it only returned #VALUE once I hit enter. Not entirely sure what I'm doing wrong, because the formula makes sense.
D.

 

[jtakw]

Can't imagine why, what Exactly do you have in A1 ?