Sumifs based on multiple criteria

[Lukma]

Hi Guys
Happy New year friends please can someone help out with a formula that can extract the spent hours which is formatted with the formula in Cell L based on Multiple criteria and faster
i have tried using SUMIFS formula but showing zero without result

ILSP_Performance Tracking Data.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M
10
11
12	Year	Manifest	Voyage	Supply	D/P	Full	Lang Rigs	Location	Arrival & Start	Depature	Total Hrs	ADNOC-1010
13	Month	Issued Month	MUS No.	Vessel	VSL	Half	Rigs & Complex	Site	Date & Time	Date & Time	Spent	Asseifiya Island
14	01-Jan-21			ADNOC-1010				Asseifiya Island	04/11/20 08:10	04/11/20 23:30	15	0
ILSP_Performance_Tracking

Cell Formulas
Range	Formula
L14	L14	=TEXT(ABS(K14-J14),"[h]")
M14	M14	=SUMIFS(Hours,Site,M13,Vessel,M12,Month,Month[@Month])

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G12:G13	Cell Value	contains "M"	text	NO
G12:G13	Cell Value	contains "Naf"	text	NO

 

[Saurabhj]

Text function returns string hence In L14, type below.

Please check and confirm.

=INT(TEXT(ABS(K14-J14),"[h]"))

Thanks,
Saurabh

 

[Lukma]

Hi Saurabhj

Thanks so much it work just right

Appreciate