Скачать или смотреть Google Sheets | Learn How to Import Data from another sheet using ImportRange Function

https://bit.ly/vt-google-sheets
In this video you will learn how to import data from another sheet from google drive. We can also do total of given range using sumproduct function in google sheets.

Syntax
IMPORTRANGE(spreadsheet_url, range_string)

spreadsheet_url - The URL of the spreadsheet from where data will be imported.

The value for spreadsheet_url must either be enclosed in quotation marks or be a reference to a cell containing the URL of a spreadsheet.
range_string - A string, of the format "[sheet_name!]range" (e.g. "Sheet1!A2:B6" or "A2:B6") specifying the range to import.

The sheet_name component of range_string is optional; by default IMPORTRANGE will import from the given range of the first sheet.

The value for range_string must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

SUMPRODUCT
The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.

Sample Usage
SUMPRODUCT(A2:C5,D2:F5)

SUMPRODUCT({1,2,3,4},{5,6,7,8})

Syntax
SUMPRODUCT(array1, [array2, ...])

array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.

array2, ... - [ OPTIONAL - {1,1,1,...} with same length as array1 by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.



Veer Tutorial Ki publish की हुई playlist इस प्रकार हैं
#veertutorial
________________________________________________
EXCEL Tutorial in HINDI ► http://tiny.cc/mnypaz
EXCEL Tutorial in ENGLISH ►
TallyERP9 Tutorial ► http://tiny.cc/951paz
Pivot Table Tutorial ►
MS Access ► http://tiny.cc/j91paz
HTML5 & CSS3 ► http://tiny.cc/w81paz
GST Tutorial ► http://tiny.cc/ba2paz

---------------------------------------------------------------------------
---------------------------------------------------------------------------
Like my Facebook page ►   / exceltips101  
Follow on Twitter ►   / veer_tutorial  
Visit us ►www.veertutorial.com
**********************************************
google sheets,conditional formatting google sheets,conditional formatting in google sheets,google spreadsheet tutorial,google sheets formulas,google sheet,google sheets tutorial for beginners,google spreadsheet,how to use google sheets,google sheet tutorial,g suite,google docs,spreadsheet,importrange in google sheets,importrange function in google sheets,importrange from multiple sheets,importrange sheets,importrange with filter,importrange,sumproduct