Conditional Sum with Many cri by formula or VBA

[MyExcel]

hi guru
i have this data
and this data grow day by data, my Real data more than 15000 row
Excel 2012

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	Truck	Type	01/Jan/2013	01/Feb/2013	01/Mar/2013	01/Apr/2013	01/May/2013	01/Jun/2013	01/Jul/2013	01/Aug/2013	01/Sep/2013	01/Oct/2013	01/Nov/2013	01/Dec/2013			Month	Truck	Type
2	Truck 3	Fl	202	886	315	399	157	380	593	271	720	482	227	961			5	Truck 3	Fl
3	Truck 1	InDir	218	803	228	603	670	374	956	495	113	581	571	596				Truck 1	S Typ
4	Truck 5	Fl	247	763	932	321	837	962	469	822	939	275	496	734				Truck 5	InDir
5	Truck 4	Fl	269	373	846	325	972	232	736	490	914	979	969	537
6	Truck 3	S Typ	321	389	261	460	450	331	202	420	690	486	269	440
7	Truck 2	InDir	328	274	747	375	410	191	516	528	919	536	347	734
8	Truck 2	Fl	345	764	678	557	928	920	821	296	181	578	954	938
9	Truck 4	Dir	363	216	449	645	890	628	778	141	432	850	199	364
10	Truck 2	InDir	387	327	444	657	287	680	512	976	723	232	794	759
11	Truck 4	InDir	398	826	854	876	322	496	661	966	467	275	673	586
12	Truck 8	InDir	501	186	501	881	748	634	919	945	397	740	748	826
13	Truck 4	Dir	505	254	467	470	837	402	126	905	760	196	997	616
14	Truck 1	Fl	510	215	953	297	584	557	146	191	350	819	274	887
15	Truck 1	Dir	568	464	586	231	746	966	957	718	491	196	494	639
16	Truck 2	Dir	638	965	157	652	277	864	849	342	842	291	372	467
17	Truck 1	Dir	648	584	234	989	340	506	403	839	238	347	765	460
18	Truck 3	Dir	693	663	998	531	810	142	951	576	140	410	796	879
19	Truck 3	InDir	753	336	277	452	201	245	951	547	694	890	385	557
20	Truck 4	InDir	759	602	234	258	676	840	426	947	311	232	466	492
21	Truck 3	Dir	816	461	139	232	463	532	958	104	996	753	290	771
22	Truck 2	Fl	884	984	447	740	279	652	573	422	344	266	806	333

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

i want to sum the Value Cri in range Q1:S4
month = 5
Truck = Truck 3 or Truck 1 or Truck 5
Type = Fl or S Type or InDir

can Excel Formula Solve it
if not
any Suggestion for good Code to fast and accurte

thank you in advanced

 

[wigi]

Hi there

That's the perfect case for the DSUM formula! Check it out please

 

[MyExcel]

wigi
i try it and i got Error
could you please make it

 

[MyExcel]

????
could any one please solve it by formula or VBA

i want VBA it will be better for me

 

[wigi]

MyExcel,

Did you spend 5 minutes in the help files looking at the DSUM and its syntax / required arguments?
I don't think so. You already replied 20 minutes after my suggestion.
With almost 500 posts at MrExcel, you should be able to get a higher standard of posting etiquette.

I prefer to donate my time and knowledge to other users.

 

[MyExcel]

MyExcel,

Did you spend 5 minutes in the help files looking at the DSUM and its syntax / required arguments?
I don't think so. You already replied 20 minutes after my suggestion.
With almost 500 posts at MrExcel, you should be able to get a higher standard of posting etiquette.

I prefer to donate my time and knowledge to other users.

hi wigi
i tried but i can't