Excel help

[Tai]

Does anyone know if it's possible to create like a tally in a cell?

I need to be able to either press a key or click on a cell and it simply adds 1 to the tally, and outputs the number/tally total.

I'm a total Excel noob. Thx A-Levels.

 

[JealY]

Why would you want a tally on an Excel spreadsheet?

That's like playing noughts & crosses on Photoshop.

 

[Tai]

Think of it as someone wanting to keep record of how many pies they sell in a shop on a daily basis. Each time they sell a particular pie, they can mark it down. But without just typing in the new number each time

 

[Robert]

It is most possible.

Need a bit more info though, as in how the data is organised etc.

Maybe attach the workbook highlighting what you want sub totalled?

 

[Tyraes]

You could use clickable arrows that when clicked +1 to the cell it's connected too.

So you'd have a table.

-> Pie 1 10
-> Pie 2 15

The arrow would change the numbers on the right. Im sure this would be easy to do. =SUM(A3+1) would be the simple sum you need to do, A3 being the pie total, so 10 and 15 in the example above.

 

[Hazuki]

Use

=counta(a1:a10)

Will count the cells with data in.

 

[Tai]

You could use clickable arrows that when clicked +1 to the cell it's connected too.

So you'd have a table.

-> Pie 1 10
-> Pie 2 15

The arrow would change the numbers on the right. Im sure this would be easy to do. =SUM(A3+1) would be the simple sum you need to do, A3 being the pie total, so 10 and 15 in the example above.

I would end up having too many arrows I think...for a list of pies along with times and days

Here's a better idea of what I want...beginning to think it's not possible though

 

[Tyraes]

The only simple way I could think is replacing the cell with a button...

 

[Robert]

Add the code to the workbook:



Double click the cell to increase its current value by 1.

So four clicks would be 2.

Hope it helps!

 

[Tai]

:O I said I was a noob talk me through it please lol

 

[Robert]

Hahaa no worries.

Open the workbook and click the developer tab.

Click visual basic and then select this workbook.

At the top will be two drop down boxes, (as in the above)
select workbook on the left then before dbl click on the right.

Type that code in.

Save workbook as an xlsm.

Job done!

Failing that...upload the workbook and I'll add it for you.

 

[Tai]

Done!! Was a lil bit different cos i'm using 2010

You da man! I never knew you were so clever :O

 

[Robert]

Haha there's probably lots you don't know about me!

Vb and excel are my work tools.

 

[Koriban]

God damn hated excel =/

Was gunna say just create a macro then put insert it into the button through developer mode, but Robert's idea is better D: