CODEWITHSUNDEEP
excelexcel-formula
0m3r
0m3r

Reputation: 12499

Excel formula How to get data count from another sheet

On C123 =COUNTIFS(Data!A:A,A123,Data!E:E,Data!G:G,B123,Data!Q:Q,"mobilepod")

its giving me Error, I know I'm missing criteria2 but isn't that an optional?

I have also tried =COUNTIFS(Data!A:A,A123,Data!E:E,"",Data!G:G,B123,Data!Q:Q,"mobilepod")

No Errors no result

enter image description here

Data Sheet

enter image description here

Upvotes: 1

Views: 2914

Answers (1)

user4039065
user4039065

Reputation:

To use an OR logic in one of the criteria for your COUNTIFS function, put the multiple ctrieria values in as an array of constants and wrap the whole thing in a SUM function.

=SUM(COUNTIFS(data!A:A, A123, data!E:E, {"DIST","DIST 2"}, data!G:G, B123, data!Q:Q, "mobilepod"))

Upvotes: 1

Related Questions