sum product on multiple columns and raws

-1

Hi ,

I am trying to find if there is any formula in excel I can use to get to a sum product on below excel where I have 3 ( vehicle name,calc1,volume )search criteria but the data is horizontal and vertical;

I need to get to this result -- 567620,4429 ( AD237*AD238+AE237*AE238+AF237*AF238) but in a more automated way since I have a very large list of cars.I was trying this formula but I get 0 : SOMMEPROD(AD237:AF246*(AB237:AB246=AB237)*(AC237:AC246=AC237)*(AC237:AC246=AC238))

Any ideas ? Thanks !

lineitem	Vehicule	Type of calc	janv.-18	févr.-18	mars-18
237	Veh1	calc1	58,81764706	86,94782609	57,15714286
238	Veh1	Volumes	1285	3633	3082
239	Veh2	calc1	45,45454545	105,2631579	100,02
240	Veh2	Volumes	2447	4212	4805
241	Veh3	calc1	0	81,6	62,5
242	Veh3	Volumes	20051	21100	19995
243	Veh4	calc1	52,6	68,2	27
244	Veh4	Volumes	1633	3937	2817
245	Veh5	calc1	71,4	184,2	35,7
246	Veh5	Volumes	1720	4594	3387
	567620,4429