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
 10.8K Get Help
 65 Global Discussions
 69 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
Check out the Formula Handbook template!