Resolved: Google Sheet Query Function – Combine 2 Steps together in Query

Question:

Pl. refer the Sheet shared below – https://docs.google.com/spreadsheets/d/1r0_oHLTcT9tmTJPgKVgkGwGWhooBM8uluwmWcC92eOk/edit?usp=sharing
Rank for diff. factors is calculated in Rank Sheet in Table A. Rank!ColL calculates combine score (D+ G + J). PF Sheet Range – Z:AE have Step wise calculation and results expected.
1 – Objective is to get results of used Query(Rank!C8:L220,”Select C,L where D > F12 & L > 0.5 order by L desc”,1) (ref. cell PF Sheet!AE17). Query is referencing RANK Sheet’s Cols.
2 – Possibility of merging Combine Score calculation as base data in Query.
Do revert is more clarity is reqd.

Answer:

I reviewed the Sheet, and I can make some suggestions.
Since you are calling 2 columns with the Query, add 1 column to the right of AE, and that one will be the new AF.
After that, modify the formula from:
to:
The reason it was not working is the use of & instead of and as mentioned here.

To make reference to a specific Cell instead of a value. You can use "&F12&", Like this:

Reference

• QUERY function

If you have better answer, please add a comment about this, thank you!