I am using a numbers spreadsheet to keep track of my baseball card inventory. I have two columns, one that list the card number and the other that list the quantity. What I'd like to do is set up a shortcut so that when I get a card I can hit the shortcut key and it will add one (+1) to the existing quantity value. How can I do this?
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
numbers shortcut to add 1 to a value
- Thread starter tedesco24
- Start date
- Sort by reaction score
I'm not sure that this is exactly what you want.... but..... I use the function "Countif" to count how many rows have an name in it (vs blank - iirc it's countif > a . ) That isn't the correct syntax - it needs a comma or something, but basically if there is anything in the cell that adds up to more than an ' a ' it get's counted. So, it tells me how many cells in a range have a name entered. I don't need to remember to hit a shortcut key, or try to remember if I've already hit the shortcut key.... it just updates itself.
Hope that helps.
Happy spring spiritual holiday, or not.
Hope that helps.
Happy spring spiritual holiday, or not.
Thanks for the reply. No, that's not what I'm looking to do, but your suggestion helped solve another problem.
I've never seen a spreadsheet do this and I think it's a great idea. You should send it to Apple as an idea for the next version.
http://www.apple.com/feedback/numbers.html
mt
Ok, then I don't think I understand the problem. What is it you are trying to count? Or do you just want something that adds up how many times you hit a key (or key combo?)
The problem with counting how many times you hit a key is that you yourself need to keep track as whether you've already counted the "thing" or not.
There may be a way to count how many times a digit appears in a cell. So for example, every time you get a card you add (for example) a '1' to the string. So for the first card there would be a '1'. For the 2nd card a '11', 3rd card '111', 8th card '11111111', etc etc Even if the string is getting really long, you are only adding single digit at a time.
Is that what you are looking for?
I appreciate you following up and trying to help. Thank you.
What I'm looking to do is keep track of the quantity of an individual card I have.
1. Lets say each weekend I buy several packs of cards.
2. I open the cards and put them in order.
3. I then open my spreadsheet.
4. I want to update the spreadsheet to reflect the new quantities. Currently I move the cursor over the quantity, hit the delete button, and type in the updated quantity (+1).
5. So I am deleting the current value and re-typing the new value
What I'd like to do is create a shortcut (say command-q), so that when I move the cursor over the existing quantity, I hit the shortcut and it updates the quantity by 1. So the quantity goes from 3 to 4, 4 to 5, 5 to 6, etc.
I've looked at the function tools, and can't seem to find one that reads the current value and is willing to increase that value by one when I hit a key.
Attachments
Are you using Numbers to record anything besides how many cards you have? I saw the sample you attached. It looks like you are recording how many cards you've added per "period", and that you generally add 1-3 cards at a time. I'm not sure how the negative #s fit in - I assume you are also disposing of cards occasionally, but you aren't tracking 'when they left the collection, just that they did.
If all you want is an adding tape, then set up a long column, and in the Inspector set it so that "Return Moves to Next Cell". Put a Sum function in the bottom cell. To use it enter a '1' in the first empty cell and hit "return". The cursor will move to the next cell, and the total is incremented by one.
It's not really a "shortcut key" but there really isn't any difference hitting something like "Option+&" and "1+Return".
Start a 2nd table on that sheet near the top, with just enough cells for the title and a cell that displays that total from the Sum on the other table. That way at least you don't have to scroll to the bottom just to see your total.
I'm surprised you aren't using Numbers to actually track each card, and it's details. Once the info is added in you can do all sorts of interesting things. Sort by name, count how many names start with each letter of the alphabet, sort by acquisition date, birth date, etc etc Plus count how many players played for each team, how many were born in what month, etc etc
Hope this helps.
If all you want is an adding tape, then set up a long column, and in the Inspector set it so that "Return Moves to Next Cell". Put a Sum function in the bottom cell. To use it enter a '1' in the first empty cell and hit "return". The cursor will move to the next cell, and the total is incremented by one.
It's not really a "shortcut key" but there really isn't any difference hitting something like "Option+&" and "1+Return".
Start a 2nd table on that sheet near the top, with just enough cells for the title and a cell that displays that total from the Sum on the other table. That way at least you don't have to scroll to the bottom just to see your total.
I'm surprised you aren't using Numbers to actually track each card, and it's details. Once the info is added in you can do all sorts of interesting things. Sort by name, count how many names start with each letter of the alphabet, sort by acquisition date, birth date, etc etc Plus count how many players played for each team, how many were born in what month, etc etc
Hope this helps.
I posted a reply above in the main section, i thought my reply would be highlighted. My bad.
OK, let me see if I get this. You have, for example, 2 cards for player #9 (I'm not looking at your sample, so this is just an example) already... You open a new package, and find 1 more card for #9. You want to be able to put the cursor into that cell and hit a key combo so that it adds 2 + 1 to make 3. You're done.
Rather than you thinking to yourself "I have 2, plus the new one makes 3, therefore I must enter the number 3 in the cell instead of the existing 2."
Is that correct?
I think you're making it harder on yourself than necessary. Why are you deleting the old entry first? If the cell says 3, then just hit 4. Unless you've double-clicked and positioned the cursor inside the cell, it will replace the contents of the cell.
I could understand if you were working with larger numbers, but it sounds like mostly single digits. Seems to be to be easier just to type the new number and move on.
jW
I could understand if you were working with larger numbers, but it sounds like mostly single digits. Seems to be to be easier just to type the new number and move on.
jW
Beats the h*ll out of me!
I'd have built a database to record everything. It would have not only told me how many cards I was still missing, but it would have spit out a list telling me exactly which ones. How many players had both a 'J' in their name, and in their birth month - but not in the month in which they got drafted. etc etc
OK - use Numbers help to look up "Stepper". I haven't used this control, but it may be what you are looking for. Good Luck