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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Operator[/TD]
[TD]Account[/TD]
[/TR]
[TR]
[TD]01/12/2018[/TD]
[TD]John Doe[/TD]
[TD]Mr Smith[/TD]
[/TR]
[TR]
[TD]01/12/2018[/TD]
[TD]John Doe[/TD]
[TD]Mr Smith[/TD]
[/TR]
[TR]
[TD]02/12/2018[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs Smith[/TD]
[/TR]
[TR]
[TD]05/12/2018[/TD]
[TD]Jane Doe[/TD]
[TD]Mrs Smith[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Operator[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD]I need a formula in here to work out how many "1st December" accounts have her name next to it[/TD]
[TD]I need a formula in here to work out how many "2nd December" accounts have her name next to it[/TD]
[TD]I need a formula in here to work out how many "3rd December" accounts have her name next to it[/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD]I need a formula in here to work out how many "1st December" accounts have his name next to it[/TD]
[TD]I need a formula in here to work out how many "2nd December" accounts have his name next to it[/TD]
[TD]I need a formula in here to work out how many "3rd December" accounts have his name next to it[/TD]
[/TR]
</tbody>[/TABLE]


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" . .