Sum if from two different column an

[Kirma]

Hey, i have the column W that sum the value from column E only if there is specific value in G column
I want to merge it to sum only if there is a value in H column like "2016c" and the is a number at the same row in E column

You can take a look at my excel file, hope you understand
[FONT=source_sans_proregular]https://mega.nz/#!cckDRTrR!zgYZxRdu-e1Obu3Q9ii1tLRNflyanuxz2MRVAsB9jrQ


Thanks[/FONT]

 

[PCL]

Perhaps try
=IF(ISNUMBER(טבלה5[@משוכלל]);IF(טבלה5[@עשיתי]="2016c";IFERROR(ROUND(SUM(SUMIF($G:$G;$K21;$E:$E)/SUMIF($G:$G;$K21;$C:$C));1);0);"");"")

 

[Kirma]

It doesnt work :\
furmula error

 

[PCL]

Can you give more details about the error, and better give a link the file with error, as you did before.

 

[Kirma]

"There's a problem with this formula"