Needing help with attendance sheet.

[Dishboy09]

I am needing some help with my attendance sheet for my new team.

The sheet has 4 types of absences on it: Vacation, Float, Flex, Military.

The sheet has 3 columns: Date-Type-Hours Used

I also have at the top of my sheet 4 columns with the hours allowed for each type, and a box with hours that have been used. I would like to use the =countif function to tally the types in the type column, and the hours used to tally up into the top columns.

Any help would be great! Thanks

 

[Oscar Cronquist]

	A​	B​	C​	D​	E​
1​	Vacation	Float	Flex	Military
2​	9​	8​	14​	21​
3​
4​	Date	Type	Hours used
5​	1/1/2018​	Vacation	9​
6​	1/2/2018​	Military	7​
7​	1/3/2018​	Float	5​
8​	1/4/2018​	Military	6​
9​	1/5/2018​	Flex	10​
10​	1/6/2018​	Float	3​
11​	1/7/2018​	Military	8​
12​	1/8/2018​	Flex	4​
13​

Sheet: Sheet37

Formula in cell A2:
=SUMPRODUCT((A1=$B$5:$B$12)*$C$5:$C$12)

Copy cell A2 and paste to B2:D2.

I think you need to explain in greater detail, please provide some example values and the desired outcome.

 

[Dishboy09]

This is exactly what i was after. Working perfectly.

Thank You

	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​	Vacation	Float	Flex	Military
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​	9​	8​	14​	21​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​	Date	Type	Hours used
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​	1/1/2018​	Vacation	9​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​	1/2/2018​	Military	7​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​	1/3/2018​	Float	5​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​	1/4/2018​	Military	6​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​	1/5/2018​	Flex	10​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​	1/6/2018​	Float	3​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​	1/7/2018​	Military	8​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​	1/8/2018​	Flex	4​
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

<tbody>
</tbody>

Sheet: Sheet37

<tbody>
</tbody>

Formula in cell A2:
=SUMPRODUCT((A1=$B$5:$B$12)*$C$5:$C$12)

Copy cell A2 and paste to B2:D2.

I think you need to explain in greater detail, please provide some example values and the desired outcome.