# Timesheet formula / Resource Planning

#### SCG

##### Board Regular
Probably a really easy one guys. Want to create a resource plan for myself. Each day is split up into a morning session and afternoon session with each session being 3 hours long.

On my spreadsheet was looking at entering companies names with in the morning session or afternoon session throughout the week. At the end I would have a formual looking up each company and adding together all the hours. For example Company A, had five sessions during the week, so a lookup or IF statement would look for the name Company A and multiple the number of times it found it by 3. E.g. 5 x 3 = 15 hrs that week. Any thoughts?

 Monday Tuesday Wednesday Thursday Morning (3hrs) Comp A Comp B Comp B Comp B Afternoon (3hrs) Comp A Comp A Comp B Comp B

<tbody>
</tbody>

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

#### gaz_chops

##### Well-known Member
Try

=SUMPRODUCT((\$B\$2:\$E\$3=\$A7)*3)

or

=COUNTIF(\$B\$2:\$E\$3,\$A7)*3

Code:
``````[TABLE="width: 325"]
<tbody>[TR]
[TD="width: 65"][/TD]
[TD="width: 65"]Monday[/TD]
[TD="width: 65"]Tuesday[/TD]
[TD="width: 65"]Wednesday[/TD]
[TD="width: 65"]Thursday[/TD]
[/TR]
[TR]
[TD]Morning (3hrs)[/TD]
[TD]Comp A[/TD]
[TD]Comp B[/TD]
[TD]Comp B[/TD]
[TD]Comp B[/TD]
[/TR]
[TR]
[TD]Afternoon (3hrs)[/TD]
[TD]Comp A[/TD]
[TD]Comp A[/TD]
[TD]Comp B[/TD]
[TD]Comp B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Comp A[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Comp B[/TD]
[TD="align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]``````

Last edited:

#### SCG

##### Board Regular
Awesome work again. Thanks.

You're welcome.

Replies
0
Views
203
Replies
4
Views
250
Replies
1
Views
208
Replies
6
Views
83
Replies
5
Views
206

1,191,625
Messages
5,987,749
Members
440,106
Latest member
davcurnutt

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

### Which adblocker are you using?

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

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