Need help with Attendance array formula...

[brockk]

hi everyone!

I'm trying to keep a tab on the employee's attendance where I have a worksheet with 24 columns (2 columns per month of the year). The 1st of the two columns is used for the attendance code and the 2nd column of the two is to represent the # of hours of absence for that particular date.

The problem:

I need a formula for the summary area that can sum all the hours pertaining to the particular code used. I left a sample of what I am trying to achieve in this worksheet. Any help or ideas is truely appreciated.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1		JAN		FEB		MAR		APR		MAY		JUN		JUL		AUG		SEP		OCT		NOV		DEC
2
3	1
4	2																	S	8
5	3	S	4.5
6	4					S	1.25
7	5											FI	8					S	4
8	6							P	3.5
9	27	V	8
10	28	V	8			L	0.5
11	29	V	8
12	30	V	8
13	31	V	8
14
15
16								ABBREV.		TL.DAYS		TL.HRS.
17				SICK				S		4		17.75		<--------------		needformula
18				FAMILYILLNESS				FI		1		8
19				LATE				L		1		0.5
20				MILITARYLEAVE				ML		0		0
21				PERSONAL				P		1		3.5
22				VACATION				V		5		40
Sheet1

 

[Domenic]

Assuming that H17:H22 contains the abbreviations, try...

J17, copied down:

=SUMIF($B$3:$X$13,H17,$C$3:$Y$13)

Hope this helps!

 

[brockk]

Thanks for the reply Domenic...

It worked like a charm! Was wondering if there was actually any hope... Much grats!

 

[Domenic]

Your welcome! Thanks for the feedback!