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
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!