Calculating A Total from specific column & days

[KiwiFruit]

Hi All,

I have an excel sheet where i want to work out peoples totals for completed tasks.

Example Data

Date	Operator	Account
01/12/2018	John Doe	Mr Smith
01/12/2018	John Doe	Mr Smith
02/12/2018	Jane Doe	Mrs Smith
05/12/2018	Jane Doe	Mrs Smith

<tbody>
</tbody>

so from the above data, i have a sheet which outlines all my staff and the days of the week, what i need is

Operator	1	2	3
Jane Doe	I need a formula in here to work out how many "1st December" accounts have her name next to it	I need a formula in here to work out how many "2nd December" accounts have her name next to it	I need a formula in here to work out how many "3rd December" accounts have her name next to it
John Doe	I need a formula in here to work out how many "1st December" accounts have his name next to it	I need a formula in here to work out how many "2nd December" accounts have his name next to it	I need a formula in here to work out how many "3rd December" accounts have his name next to it

<tbody>
</tbody>

and so forth for all the other people and days of the year.

Any help would be highly appriciated

 

[James006]

Hi,

Just make your life simple ... and Insert a Pivot table ...:wink:

Hope this will help

 

[Repush]

checkout "SUMPRODUCT" . .