Sum of Value meeting countifs criteria

I have a table in Sheet1 with certain columns.
Column K - Site
Column M - Department
Column N - Service affected

I am using a countifs function to count according to certain criteria's. Below is a portion of the countifs i am using
=COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*DDN*")+COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*IPC*")+COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*NGN*")

Issue
I am trying to add the value of one column where the row has been counted.

i.e Assume Percentage is column Z
cell A3 = FVDN

Location Department Service Affected percentage
Lautoka FVDN DDN 1%
Lautoka IPC IPC 2%
Suva FVDN DDN 2%
Nadi FVDN ISM 5%
Lautoka FVDN DDN 6%

so if my countif crietria is if
=COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*DDN*")+COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*IPC*")+COUNTIFS(Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*NGN*")

only 2 of the rows meet the criteria so the result will show 2

I want to add the values of the percentage column that met the countifs criteria. I.e 1% + 2% = 3%

I tried the sumifs equation but not getting the correct answer

SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*DDN*")+SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*IPC*")+SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*NGN*")

Two things to check:
Is your formula on Sheet1? If not, you need to add Sheet1! before $Z:$Z - as with the other elements of the formula.
Does column Z contain numbers formatted as percentages, or just text that looks like a percentage? An easy way to tell is to enter a simple formula like =Z3+Z4 into a cell, and see if it gets you the expected result.

Thanks for pointing that out. it should have been Sheet1!$D:$D.
however it still does not give the correct value.
the values in column D in sheet 1 is formatted to general values eg. 99.85624, 98.23111 etc

Dear Joym, can you share the excel sheet which you are doing in it.

I can not attach the file there is something wrong on da page

Your formulas are three sumifs added together. Can you try each sumif separately to see if it gives what you would expect.

It would be a lot easier if we could see the file. If you can't upload it directly to this site, could you upload it to a sharing site (e.g. Google drive or similar) and post the link here?

Please find thge excel file at the link below
https://drive.google.com/file/d/0B2H...ew?usp=sharing

The Sumifs in Sheet2 column S
the range for the Sumifs is sheet1!$D:$D ($z:$z was just used as an example)
I actually want to calculate the average - ill divided the sumifs by the value in $F3
=(SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*DDN*")+SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*IPC*")+SUMIFS($Z:$Z,Sheet1!$K:$K,"Lautoka",Sheet1!$M:$M,$A3,Sheet1!$L:$L,"*NGN*"))/$F3

Would i be able to achieve this using Averageifs

Averageif averages each individual range. Adding together three averages is different to taking a single average.

Thanks for pointing that out. So my initial method was correct using the sumifs and the dividing by cell $F3 Where the Cell f3 conatins the count value for the criteria.

Any help on why the Sumifs isnt working correctly

Thanks for the help it was very informative and actually did bring results.
However there is something wrong. the number indicated in column F3 should correspond with number the a percentage value in O3.
what i mean is since i used the same criteria for both but using the different functions the results should be related. So if column F3 has a count of 1 the value in O3 should be a minimum value of 87.xx as thats the minimum value in column D.

can i also use this criteria to add anything that does not meet the criteria?

thank you that was very helpful. there is one more thing i would like to achieve. I need to sum everything that does not fit the initial criteria. Is there a way this can be achieved. I have tried researching on this but could not find a simple solution other than writing a new criteria.