#Invalid Operations

Shannon Lacerda

I have what I thought is a simple formula, but I get the #Invalid Operations

Genevieve P.

Hi @Shannon Lacerda

You're missing the second cross-sheet range which tells the formula what column to look into to find the month.

Ex:

=COUNTIFS({Elevated Bid Proposal}, "Bid", {Bid Due Date Column}, IFERROR(MONTH(@cell), 0) = [Month Number]@row)

Note that I also wrapped an IFERROR around the MONTH function in case there are blank cells in your Due Date column. Does this make sense?

Cheers!

Genevieve

Jason Albrecht

Hi Shannon,

The way I understand the COUNTIFS Function is that there needs to be a criterion for each range.

Maybe the "= [Month..." in the formula needs to change to " , = [Month.. " as it seems to me the 2nd range MONTH(@cell) needs the criterion of [Month Number]1 ?

Hope this helps?

Shannon Lacerda

@Paul Newcome Hi could you please take a look at my formula and see what I am doing wrong. When I remove the date aspect of the formula is works. I cant figure out what the issue with the date is?

Thanks so much

Genevieve P.

Hi @Shannon Lacerda

You're missing the second cross-sheet range which tells the formula what column to look into to find the month.

Ex:

=COUNTIFS({Elevated Bid Proposal}, "Bid", {Bid Due Date Column}, IFERROR(MONTH(@cell), 0) = [Month Number]@row)

Note that I also wrapped an IFERROR around the MONTH function in case there are blank cells in your Due Date column. Does this make sense?

Cheers!

Genevieve

Shannon Lacerda

@Genevieve P. Thank you that worked.

Paul Newcome

@Shannon Lacerda My apologies for the delayed response. Things have been pretty busy lately. It looks like Genevieve was able to help you out.

@Genevieve P. Thanks again for picking up when I am slacking off. Haha

Genevieve P.

Haha, not slacking! This is a community after all - it takes teamwork. 🙂

I'm glad that worked for you, @Shannon Lacerda!