---
title: Count Contact Records with a Filter Applied
description: With Rollup Helper, you can create a rollup in Salesforce that displays a count of the total records that meet some condition on the parent.
---

[Rollup Helper Use Case Library | Passage Technology ](https://www.passagetechnology.com/rollup-helper-use-cases)

# [Count Contact Records with a Filter Applied](https://www.passagetechnology.com/rollup-helper-use-cases/count-contact-records)

 Written by [Passage Technology](https://www.passagetechnology.com/rollup-helper-use-cases/author/passage-technology) | May 01, 2014

Problem: You need to display a count of the total records that meet some condition on the parent, and Rollup Summary Fields are NOT an option. 

For example, you may get asked, "How many VP Contacts do I have on any given Account?"

## Solution: Start by creating a new custom field (using Number as the data type).

Create a new custom field (using Number as the data type) on the object you want the results to reside, in this case Account. We named the field, "# of VPs."

To create the rollup:

- Select *Account* as the Target Object
- Select "# of VPs" as the Target Field
- Select *Contact* as the Child Object
- Use *Account ID* as the relationship field
- Select *Count* as the Type of rollup. Note: IsDeleted is the default source field used for count rollups since it is a simple boolean field that exists on all records.
- Create a new filter 
    - Name the filter in step 1, then skip to step 3
    - In step 3, select the "Title" field
    - Select "Contains" as the operator
    - Enter "VP" for the criteria
- Save your filter, and then save and run the rollup

 

[View full post](https://www.passagetechnology.com/rollup-helper-use-cases/count-contact-records)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Passage Technology"
  },
  "dateModified" : "2026-04-28T15:08:50.210Z",
  "datePublished" : "2014-05-01T02:24:34Z",
  "headline" : "Count Contact Records with a Filter Applied",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.passagetechnology.com/rollup-helper-use-cases/count-contact-records",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Rollup Helper Use Case Library"
  }
}
```