Add Count Automatically + more Excel tips
January 13, 2015
In this week's Excel news, you'll see how to automatically enter a count field in a table, and much more., and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.
Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.
In a named Excel table, you can add a counter field that fills in automatically. This is can be used in summary functions, or added to a pivot table, even in calculated fields, like the one mentioned below.
Click here to see the details: Add a Counter Field to Excel Table
When you create a calculated field in a pivot table, you can refer to other value fields. However, the calculated field always uses the SUM of those fields, even if you have them displayed as a COUNT.
To fix the problem, you can add a counter field in your source data, and its sum will act as a count.
See the details in my blog post, and download the sample file: Create Calculated Field With a Count
Here are a few of the Excel articles that I read recently, that you might find useful:
Here are some upcoming events, courses, recently published books, and other new items, related to Excel:
The SUBSTITUTE function replaces characters within text, either for all instances, or for one specified occurrence. It can be used on its own, and I often combine it with other functions, to create powerful formulas.
Click here to watch the short video that show how it works: SUBSTITUTE Function Video.
We got a new gadget for our kitchen, and it's useful, but one of the silliest things that I've seen. His name is Spud Dude, and his spikes hold a potato, while you peel it. I've used it a couple of times, and it keeps my fingers safe, and makes me smile too!
And if you're from Canada, it might remind you of the Stompin' Tom Connors song, Bud the Spud. (YouTube link)
That's it for this week! If you have any comments or questions, send me an email.
Last updated: February 20, 2020 6:50 PM