# Counting Monthly Intakes per Segment

✭✭✭✭✭

Hi all I am trying to figure out why my formula isn't running correctly. I want to count how many times a specific segment put in a request per month. For Example if the nurse team made 10 request in January and 12 in February. I have about 10 other segments to fit in. I also only need to count Parent rows which are identified as "TOP".

I am counting the total completed work and current intakes hence the "+".

=COUNTIFS({Completed - Create Date}, IFERROR(MONTH(@cell), 0) = MONTH(1), {Completed - Create Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Completed - Parent ID}, ="TOP", {Request - Segment}, ="Nurse") + COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = MONTH(1), {Request - Create Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), {Request - Parent ID}, ="TOP", {Request - Segment}, ="Nurse")

I feel like the problem is with the Month(1) section but I'm not certain.

Thanks!

Tags:

• Overachievers Alumni

You should be able to replace MONTH(1) with 1. The MONTH formula will simply return the number of the month in the associated date (1-12). There is no need to wrap the month number in the MONTH formula again.

• Overachievers Alumni

You should be able to replace MONTH(1) with 1. The MONTH formula will simply return the number of the month in the associated date (1-12). There is no need to wrap the month number in the MONTH formula again.

• ✭✭✭✭✭

Thank you for teaching me how to use that correctly @David Tutwiler!

I knew it had to be something silly.

• Overachievers Alumni

No problem. Glad it's working for you.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!