Search code examples
google-sheetsgoogle-sheets-formulacountif

Count amount using countifs

There are two tables. In one table, the columns are named after the month numbers. The rows are types of meetings: Designer, Estimator. In the second table Column A is the date of the deal. Column B is the type of meeting. How to calculate the number of designers in January in the first table? I tried

=arrayformula(COUNTIFS('All'!B:B;"Designer";MONTH('All'!A:A);1))

Also I tried it withount arrayformula but still doesn't work

Solution

  • You can try this:

    =arrayformula(COUNTIFS('All'!B:B;"Designer";{MONTH('All'!A:A)};1))

    I just added brackets around your month formula.