Hello,
I'm trying to make a formula to count the number of jobs by builder for the month of January to go into my sheet summary.
I managed to get the formula working for January however when i copied and pasted the formula and changed the name of the builder i got #invalid operation.
The working formula is as follows,
=COUNTIFS(Customer:Customer, "Burbank", [Delivery Date]:[Delivery Date], IFERROR(MONTH(@cell) = 1, =0))
The invalid formula is,
=COUNTIFS(Customer:Customer, "HICKINBOTHAM", [Delivery Date]:[Delivery Date], IFERROR(MONTH(@cell) = 1, =0))
I tested a theory that the name "hickinbotham" was too long and it seems to be right as the formula works builders with smaller names.
the formula works with 11 characters but not 12 characters (as i tried "hickinbotha" and it worked).
Is there anything I can do without having to change the name of the builder?