# #Invalid Operations

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

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

• ✭✭✭✭✭✭
edited 09/15/21

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?

Hope this helps and that you have a great day,

Jason

• @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

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

• @Genevieve P. Thank you that worked.

• ✭✭✭✭✭✭

@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