HOW TO CALCULATE TOTAL OT

[dickson]

NAMES	FRI	SAT	SUN	MON	TUE	WED	THU	OVERTIME
LANCY	C-RM	C12R	C-RM	A12R	C12R	C12R	C-RM	HERE I NEED TOTAL OT HOURS
DIPU	A12R	C12R	A12R	C12R	C12R	C12R	C12R	E.G 48
JIJO	C-RM	C12R	A12R	C12R	C12R	C-RM	C12R
BENTY	A12R	C12R	C-RM	C12R	C-RM	C12R	C12R
	SHIFT	OT HOURS
	C-RM	2						HOW TO CALCULATE TOTAL OT HOURS
	C12R	6
	A12R	12

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Fluff]

Thanks for updating your profile.
How about

=SUMPRODUCT(SUMIFS($C$10:$C$12,$B$10:$B$12,B2:H2))

 

[dickson]

Thanks for updating your profile.
How about

=SUMPRODUCT(SUMIFS($C$10:$C$12,$B$10:$B$12,B2:H2))

i am getting 0

 

[Fluff]

Just realised that you have posted this in the "General Discussion & Other Applications" section of the board. Is this for Excel?