Formula for Counting Days/Orders

mscola · May 16th 2013

Hello

I've got a spreadsheet with a table called orders. I do not know how to calculate the day with the most orders
and the number of orders for that day.

Can someone please help me?

Thanks a lot

Massimo

[ATTACH=CONFIG]53712[/ATTACH]

**NBVC** · May 16th 2013

Re: Formula for Counting Days/Orders

In F5:

=INDEX(Orders[Date],MATCH(MAX(COUNTIFS(Orders[Date],Orders[Date],Orders[Day],Tabelle3[[#This Row],[Day]])),COUNTIFS(Orders[Date],Orders[Date],Orders[Day],Tabelle3[[#This Row],[Day]]),0),)

confirmed with CTRL+SHIFT+ENTER not just ENTER, then copied down

in G5:

=COUNTIF(Orders[Date],Tabelle3[[#This Row],[Date with most orders:]])

confirmed with just ENTER and copied down

mscola · May 17th 2013

Re: Formula for Counting Days/Orders

Hi

The formula works but it is a bit slow. Maybe because it's a array formula?

Massimo

Formula for Counting Days/Orders

Participate now!

Share