What could I be doing wrong in my formula

Nkeiruka. Aguocha

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)

Ray Lindstrom

Hi @Nkeiruka. Aguocha,

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

Ray Lindstrom

Hi @Nkeiruka. Aguocha,

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

Nkeiruka. Aguocha

Hi @Ray Lindstrom ,

😀That fixed it. Thank you so very much!!!

Nkeiruka. Aguocha

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!

Ray Lindstrom

@Nkeiruka. Aguocha,

You could try using the MONTH and YEAR functions. Here's some information on them.

https://help.smartsheet.com/function/month

https://help.smartsheet.com/function/year