Google Sheets formula find highest or average from different sheets based on name

Question

Hello stackoverflow, i want to fill cell on Sheet B based on Sheet A data. i tried some guide "Max If (Max Value with Condition)" but its doesnt work give 0 (zero) value instead.

thank you

Answer 1

try:

=QUERY(SheetA!B:G; "select B,max(G),avg(G) where G matches '^[0-9]+' group by B")