I am trying to create a formula that shows what month it was sent to POC

Jairo Sibrian

I am trying to have this formula shown on a dashboard that shows how many were completed every month

KPH

You can use a COUNTIF formula, for example

=COUNTIF(Month:Month, 3)

would count the number of rows where the Month is 3.

However, this will not work if there are errors in your data. The Invalid Data Type error messages I can see in the screenshot will prevent the COUNTIF from working. If you change the formula that generates those to return nothing when errored, rather than the error message, the COUNTIFS will work.

You probably have a column formula like this:

=MONTH([Date Order Sent to POC]@row)

That returns the Month like this

If you amend that to:

=IFERROR(MONTH([Date Order Sent to POC]@row), "")

The error message will be replaced with "" (nothing). So the COUNTIF formula will be able to count.

To have this display on your dashboard, you can put the COUNT formula in another sheet and use a cross sheet reference to the original. Or your could create a report and summarize by the month column to have this create a chart.

Let us know if you need any more.

Hope this helps.