Need a macro instead of SUMIF & COUNTIFS formula

Hi
I have 400 csv file that they are output of a program and now I need calculate something on them
first of all I find a code to import all of my csv to an excel file
then by using SUMIF and COUNTIF I calculate my needs But I Need to know if there are better way

I Used Something like this

=IF(J2=$E$2,COUNTIFS($A$3:$A$38,$A$43,E3:E38,"c")/(COUNTIFS($A$3:$A$38,$A$43,E3:E38,"c")+COUNTIFS($A$3:$A$38,$A$43,E3:E38,"w")))

and

=IF(F2=$F$2,SUMIF($A$3:$A$38,$A$44,F3:F38))

ExcelForum.xlsx
and as you see in the attached file the output is not suitable for bigger file
is there any better solution ?

thank you in advanced
Keyvan,