Counting details from multiple sheets

Friends!

Like the subject entails, that's pretty much it.

I have three sheets and another for summarizing these.

Basically, the sheets are about test drives committed during the month.

In the summary sheet, I would like to count how many test drives are done by each sales executive and count the number of vehicles used.

The summary table is divided into three section of dates, each count is to be returned into its section of the table using formula.

I hope the file is self-explanatory.

Please do let me know should there be any more clarity required to explain.

Thank you very much in advance!

You forgot to add some expected results (manually calculated).

Are you still using Excel 2010 or something newer?

See attached: changed format and used dates as column headings.

in B2

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&Sheets&"'!C2:C100"),$A2,INDIRECT("'"&Sheets&"'!B2:B100"),">="&B$1,INDIRECT("'"&Sheets&"'!B2:B100"),"<="&B$1+9))

Copy across and down

In G2

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&$F2&"'!B2:b100"),">="&B$1,INDIRECT("'"&$F2&"'!B2:B100"),"<="&B$1+9))

"Sheets" is named range of your tab names

Originally Posted by JohnTopley

See attached: changed format and used dates as column headings.
...

You, Sir, are the king of all!

Thank you very much!

You're welcome.