Advice on creating a formula for two different conditions

[jankrulak]

Dear All,

I was wondering whether anyone here could point me how to and whether it is even possible to create a formula for my issue?

I am working on the spreadsheet which cannot contain any macros, only formulas which makes everything a bit more difficult. The issue which I have come across is to write a formula for coordinates of four points meeting coordinates of other four points.I know, I sound confusing so please allow me to explain it below:

If coordinates of top piles Lx (cell no. T9) & Ly (cell no. U9) are met with coordinates in cells no. F9:G38 and if coordinates of bottom piles Lx (cell no.T14) & Ly (cell No.U14) are met with coordinates in cells no. F9:G38 then number of piles in cell no. U16 is cell no. E4+2.

Could anyone advice how this could be achieved?

I hope above makes sense, if not please let me know.

Thank you in advance for your help on this.

Kind regards,

Jan

[XLent]

perhaps:

=E4+FLOOR(SUMPRODUCT(COUNTIFS($F$9:$F$38,CHOOSE({1,2},$T$11,$T$14),$G$9:$G$38,CHOOSE({1,2},$U$11,$U$14))),2)

that said, you might need to elaborate on what "met" means -- in the above this is an exact AND match (T11+U11, T14+U14)...

so, with the values provided in the sample this will return 0 (18)... but, with values of 5.1, 1.4, 0.3, and 1.4 in T11, U11, T14, and U14 respectively you would get +2 (20)

[jankrulak]

Thank you XLent for your response!