#INVALID OPERATION while using COUNTIFS

Mindfull
Mindfull ✭✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

Hi,

I am trying to fetch a value based on three columns the columns are as under:

I am trying to filter out how many requests are there in the two types against each "LOB category", I tried Count IF and phrased it as :

=COUNTIFS({DocRequestTypAPAC}, $[Document Request Type]@row, {LOBIRS} = "IRS", {RRmnth}, "October 2020"). it is throwing and #INVALID OPERATION Error.

Please hep to get corrected.

Prajna

Best Answer

Answers