Find or Average Formula

[Jagat Pavasia]

Hi I have data as above excel Image.

I want that if I type invoice number in E16 than it should find from A3 to A12.
After that find date as in D19 from E3 to E12, I3 to I12 & M3 to M12 and sum of Days (which is from C3:C12, G3:G12, K3:K12)
After sum of days than divide by count how many same date found.

In, Second Image I typed Manually answer, So, please help me to which formula can I input in E19 ??

 

[kvsrinivasamurthy]

In E19 copied down

=SUMPRODUCT(($A$3:$A$12=$E$16)*(($C$3:$C$12*($E$3:$E$12=$D19))+($G$3:$G$12*($I$3:$I$12=$D19))+($K$3:$K$12*($M$3:$M$12=$D19))))/SUMPRODUCT(($A$3:$A$12=$E$16)*($C$3:$N$12=$D19))

 

[Jagat Pavasia]

In E19 copied down

=SUMPRODUCT(($A$3:$A$12=$E$16)*(($C$3:$C$12*($E$3:$E$12=$D19))+($G$3:$G$12*($I$3:$I$12=$D19))+($K$3:$K$12*($M$3:$M$12=$D19))))/SUMPRODUCT(($A$3:$A$12=$E$16)*($C$3:$N$12=$D19))

yes, it is working as I want....

thank you so much kvsrinivasamurthy.....

Now, I want another please help.

Now I want, answer of amount in F19 with same condition as we have enter formula in E19.
But, in addition that sum all negative amount and sum all positive amount and answer which is bigger.


for example :
-25$ , -50$, -10$, 150$ = than answer 65$
100$, -25$, -150$ = than answer -75$
-25$, -10$, -5$ = than answer -40$

 

[kvsrinivasamurthy]

In F19 copied down

=SUMPRODUCT(($A$3:$A$12=$E$16)*(($D$3:$D$12*($E$3:$E$12=$D19))+($H$3:$H$12*($I$3:$I$12=$D19))+($L$3:$L$12*($M$3:$M$12=$D19))))

 

[Jagat Pavasia]

In F19 copied down

=SUMPRODUCT(($A$3:$A$12=$E$16)*(($D$3:$D$12*($E$3:$E$12=$D19))+($H$3:$H$12*($I$3:$I$12=$D19))+($L$3:$L$12*($M$3:$M$12=$D19))))

THANKYOU FOR QUICK REPLY......IT'S WORKING AS I WANT......