Am trying to create a spreadsheet to help with buying / selling things (neopets - sad but true!) and was wondering if there was a calculation I could enter to tell me how many items I've bought in a day. One column contains all items bought - so I could just count them, but would be easier to set a calculation that would do it automatically!
If you have the names of the items you bought in Column A, thenwhich will count all cells in column A which have something in them. Is that what you are asking for?
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Or, if all the purchase quantities are in the A column starting at A2, then:
Change A18 to whatever row you want to stop at.Please Login or Register to view this content.
Last edited by JBeaucaire; 11-10-2008 at 09:41 PM. Reason: Add example workbook
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks