IFERROR match part of text value with the use of COUNTIFS AND SUMIFS

Hello forum,

Have a problem with trying to match a validation list that has only part of the text that the cell values has.
I'm trying to get around another problem (of selecting all in the validation list). As all values starts with the name "AREA" in table column "REGION" sheet "Data", I hope to be able to select all rows and do the calculations.
I need a way to get all values that has the first 4 characters with name "AREA" and do sumifs and countifs.

I have attached a sample file with the tables and validation lists
Its in cell C5 in sheet Dashboard where the dropdown list shows "AREA" that I need to match. All other works as it is an exact match....
Any suggestions have to do this?

Thanks

is this what you are looking for in D8 (copied down)?
=IF($C$5="AREA",COUNTIF(koncept,$C8),IFERROR(COUNTIFS(REGION_name,$C$5,koncept,$C8),"-"))

@Sambo kid, works perfect for COUNTIF, but SUMIF I can't get my head around, do a similar on next column with SUMIF and SUMIFS for the column konceptID is it has numbers.
I can't the summery there... just gives me "0" so far...

Actually I did!!!

Thanks

Where is the sumif supposed to go? What are you trying to sum?

this would be the sumif/sumifs if you are (for some reason though it doesn't make sense to me) looking to sum the konceptID column...
=IF($C$5="AREA",SUMIF(Table1[Koncept],$C8,Table1[konceptID]),IFERROR(SUMIFS(Table1[konceptID],Table1[REGION],$C$5,Table1[Koncept],$C8),"-"))

ok, glad I was of some help, AND thank you for the rep!