Jump to content

Countif function


This topic is 2074 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I want to create a function that works like "Countif" in Excel. For example, to count only the text value "7" in a series of cells in Excel I use:

=COUNTIF(A2:Z2,7)

which ignores any other text value and counts the occurrences of the value "7". In FMP how do I get the same result?

Link to comment
Share on other sites

I want to create a function that works like "Countif" in Excel. For example, to count only the text value "7" in a series of cells in Excel I use:

=COUNTIF(A2:Z2,7)

which ignores any other text value and counts the occurrences of the value "7". In FMP how do I get the same result?

ValueCount( FilterValues( List( relation::Field); "7"))

Link to comment
Share on other sites

  • 10 months later...
  • 8 years later...
  • Newbies

Thank you ALL contributors to this feed! This problem has quite simply been doing my head in for a few hours. 

I used the following:

ValueCount( FilterValues( List( RELATED TABLE I WANTED TO SEARCH::THE FIELD I WANTED TO COUNT THE NUMBER OF REPETITIONS ); THE MATCHED FIELD))

Example below:

ValueCount( FilterValues( List( Car Inventory::Car Type); "Landrover"))

Result:

The number of records that match the car type 'Landrover' within the table inventory

Edited by bmftn
Link to comment
Share on other sites

This topic is 2074 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.