Skip to main content

Count number of ticks returned by Lookup, where field is a Checkbox

  • February 24, 2017
  • 1 reply
  • 35 views

  • Participating Frequently

I have a Lookup which points to a Checkbox field on another table. The Lookup returns a ‘tick’ character for each of the records where a tick is present.

(The field called “Present” is the Checkbox. The ‘tick’ characters that are returned can be seen beneath the ‘Cancel’ button.)

What formula should I use in order to return a count of the number Checkboxes which have been ticked?

Graham

This topic has been closed for replies.

1 reply

  • Author
  • Participating Frequently
  • February 24, 2017

OK. Thanks to the excellent Help files, I’ve discovered that I can achieve this as follows:

Problem solved!

G