Excel Calculated Field - How to use Count function

Posted on 2014-08-03
Last Modified: 2014-08-10
Hi There,
Can someone provide an example of a workbook with a calculated field in a pivot table, where a formula has been used with the count function in the "Insert Calculated Field" formula?

I'm just trying to understand how to use the various features of calculated fields.

THank you.
Question by:rav_rav
    LVL 14

    Accepted Solution

    Hi there,

    Have you looked at Debra Dalgleish's website? She has many items, especially covering PivotTable's. Here is her page on calculated fields, which even has a short video showing how to add one:

    Easiest way to add a count of a field is to drag that field to the Values area. If it's a textual field you should be good to go, because it defaults to Count for text data (Count with PivotTables is a COUNTA, whereas Count Numbers is like the COUNT function). If the field is numeric, change the field settings from Sum to Count. I've attached a sample file showing a Count field.


    Zack Barresse

    Author Closing Comment

    Thanks Zack

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now