Calculating A Total from specific column & days

KiwiFruit

New Member
Joined
Dec 12, 2018
Messages
1
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hi,

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

Hope this will help
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top