Count assistance

[#1]

• Count all entries that meet the criteria FIELD1 with answer ‘YES’ and FIELD2 with answer ‘NO’ <Note** that this combination will be the argument we use to identify all COMP that were flown by a drone> TAKE OUT NULLS.

  • Display total count

[swuehl]

Not sure, but maybe

=Count( {<FIELD1 = {'YES'}, FIELD2 = {'NO'} >} YourCountEntryField)

[#3 · Accepted solution]

=((count(field1)='YES')+ (Count(field2)='NO')))

will this work?

[swuehl]

Does it work? I believe it won't return a total count of your field(s), but if you think that this is the correct answer...