0

Like COUNTIFS in Excel

Team,

How do I count the number of times a criteria is met in a field. Basically, the same as COUNTIFS in Excel.

 

V/r

1 reply

null
    • Nick
    • 3 yrs ago
    • Reported - view

    Like this

    ---

    Excel example:

    =COUNTIF(D5:D12,">100") // count sales over 100

    ---

    Ninox:

    cnt(select TableName where YourField > 100)

    or

    cnt(select TableName[YourField > 100])

Content aside

  • 3 yrs agoLast active
  • 1Replies
  • 725Views