What formula/script can be used in Google Sheets to transfer a value from one sheet to another sheet?

Question

Google

Greetings!
You need a formula or a script for the G-Table so that you can transfer data from one sheet to another, as shown in the attached picture.

Thank you in advance!

Answer 1

If I understand correctly, just like in regular Excel. Write = and poke into a cell on another sheet, well, further if you need a formula.

Answer 2

Made for your example on the screen:
For Pineapples and bananas (column H Sheet2) for the 29th =COUNTIFS('Sheet2'!$G:$G;$A3;'Sheet2'!$H:$H;B$1)
For Dry juicy (column I Sheet2) =COUNTIFS('Sheet2'!$G:$G;$A3;'Sheet2'!$I:$I;D$1)
In principle, the syntax is the same as the countifs function of regular Excel. Yes, and you can write not COUNTIFS but countifs
Syntax is here