I'm newbie about google sheet..

How to importrange from different sheet based on name of country this my step:

  1. the formula placing in sheet REKAP ALL IKU cell B5-B10---(in col. "country"). I want single formula if possible.
  2. sheet SBSK (1/13) as data sources with data from C7 till H12

Here link my sheet:

Anyone help me out.

1 Answer 1



  1. koyone langkah sing ora ana guna kanggo nyiapake rumus kanggo unsur sing wis ana ing kolom B (saka B5 nganti B10) SBSK (1/13)
  2. Mulane sampeyan mung kudu ngimpor kabeh kolom saka B7: H12

  1. it would seem a useless step to prepare a formula for elements you already have in column B (from B5 to B10) of SBSK (1/13)
  2. for this reason you just need to import all the columns from B7: H12

=query('SBSK (1/13)'!B7:H12;"select * ")

Yen aku ora ngerti apa sing sampeyan pengin entuk, aja ragu-ragu takon pitakon sing luwih rinci lan luwih spesifik

If I don't understand what you wanted to achieve, feel free to ask further and more specific questions

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.