Find and sum values from a range by multiply criteria

[ccsmith]

Hello everybody,

I attached a sample file. I have a database (J2:Q24) from which I have to collect some data by multiply criteria.
Example: I have to collect from "value" columns K-M-O-Q the data which meet "criteria" columns E-F.
I solve the gathering with a SUMIF function in array formula (CTRL+SHIFT+ENTER), but it is too complicated and takes a long time in a huge database.
I would like to ask for your help to create a macro for collecting values.
Moreover, the macro should collect all data from database (J2:Q24) which contains the main number (column A) and enything which begins with this number (example 1020; 1020A; 1020B; 1020C etc.)
Please see the uploded sample file.

[tony h]

Try this.

I have a feeling there ought to be something neater.

[ccsmith]

"Try this." Which one? I didn't find your attached VBA program.
I would like to collect data from a range by given criteria.
Example: Find the values next to each number "1020 and every items which start with 1020 like 1020A, 1020B etc." whitin a start and an end date. I could do it with SUMIF function (=SUM(IF(($J$2:$J$24=$A2)*($I$2:$I$24>=$E2)*($I$2:$I$24<=$F2);$K$2:$K$24;0)) in array formula, but it is too slow and complicate in a huge database.
Please see my attachment.