What could I be doing wrong in my formula
Hello,
I'm trying to count how many "CAR" are "In Progress" for each month but I'm getting the "Incorrect Argument" notification. Can someone tell me what I'm doing wrong? Thanks!
=COUNTIF({CAR Log Range 1}, "In Progress", {CAR Log Range 2}, "CAR", {CAR Log Range 4}, IFERROR(MONTH(@cell), 0) = 6)
Best Answer
-
Looks like you should be using the COUNTIFS function instead of the COUNTIF function. I say this because you have multiple ranges and criteria that you're evaluating.
All the best,
-Ray
Answers
-
Looks like you should be using the COUNTIFS function instead of the COUNTIF function. I say this because you have multiple ranges and criteria that you're evaluating.
All the best,
-Ray
-
Hi @Ray Lindstrom ,
😀That fixed it. Thank you so very much!!!
-
Hi @Ray Lindstrom,
I have another question if I may...How do I make my formula Identify the months in years? For example, in my row, I have the months from 2022 and stated again for 2013, so when I'm trying to count how many "CCR' were entered Jan(1)2023, its stating the same amount as 2022. Thanks!
-
You could try using the MONTH and YEAR functions. Here's some information on them.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!