Cross sheet countifs
Hi,
Attempting cross sheet counts for totals by month and year the number of times "x" appears, in the example below I selected "DTS" from the other sheet. I can get the total column count from the other sheet with =COUNTIFS({Container COMPLETED Range 2}, "DTS") but when I add all in italic below I get #Unparseable. I have also tried with AND( before IFERROR and get #Incorrect Argument Set.
Range 2, is my other sheet column that contains "DTS"
Range 5, is my date column in the same sheet.
=COUNTIFS({Container COMPLETED Range 2}, "DTS", ({Container COMPLETED Range 5}), IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1))
Help - cheers.
Cheers.
Forever forwards Backwards never.
Best Answer
-
There are a few too many parenthesis. Give this a go...
=COUNTIFS({Container COMPLETED Range 2}, "DTS", {Container COMPLETED Range 5}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1))
Answers
-
There are a few too many parenthesis. Give this a go...
=COUNTIFS({Container COMPLETED Range 2}, "DTS", {Container COMPLETED Range 5}, AND(IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1))
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives