Count month orders by costumer

Javier

Hi.

I'm trying to figure out how to count the number of orders on a spreadsheet based on date.

The table has more or less this structure, although with a lot more fields.

What I want it to do is to count on a separate sheet the amount of orders of the current month, what I have planned is something like this:

• A current date cell with the today formula, so that the value updates daily ->TODAY().
• A month cell that looks up the month based on the current date cell I mentioned before.

Below,

• A list of the costumers.
• The number of orders placed on the current month.

The problem is, I've been trying to do it through formulas and the results haven't been what I expected, like this one that ends up counting the amount of days in which the costumer has placed orders.

=COUNTIFS({Dates}; <TODAY(-30); {CostName}; [Costumer Name]1)

Any help will be appreciated.

Paul Newcome

Try something like this...

=COUNTIFS({Other Sheet Date Column}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Other Sheet Customer Name Column}, [Customer Name]@row)