getting total values after search by list validation

hi

i would some help to add total row to my code after search by list validation i put the result what i would in sheet2 the search in c3 in sheet2 and press search then get data from sheet1 the standard of search it depends on column a in sheet1 my code misses insert total row when search specific data i hope to find help from somebody

thanks sobi ,it works perfectly could tweak a simple code firs of all i would copy also currency in column h not shows in sheet2 the second if i adjust the code no need button search only choose from list validation then show data without search button

well done sobi , it awesome your tweak thank you so much