# Contextures News 20150113

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.

## Add a Counter Field to Excel Table

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.

## Calculated Field With a Count

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

## More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

## Excel Announcements

Here are some upcoming events, courses, recently published books, and other new items, related to Excel:

• Amsterdam Excel Summit: Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year's summit was an outstanding success, and registration will open soon, for this year's event.
• Excel Dashboard Course: Mynda Treacy has opened registration for her acclaimed Excel Dashboard course, and you'll get 20% off, if you sign up by January 22nd. See details in the Featured Excel Product section, below.
• Mynda is also offering a free introductory webinar on How to Build Excel Dashboards. Get the details on this one-hour session, and sign up for a date and time that is convenient for you.

## Video: SUBSTITUTE Function

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.

Debra Dalgleish
dsd@ contextures.com

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

Last updated: October 29, 2021 7:02 PM