[Google Sheets] 다른 시트 참조 합산 구하기
합산은 SUM을 이용하고 다른 시트 범위값은 QUERY 이렇게 2가지 기능(Function) 이용해서 구하면 됩니다.
SUM(값, [여러값...])
QUERY(범위, 쿼리, [헤더 행 수] )
합산
다른 시트값을 참조해서 합산을 구하는 수식은 아래와 같습니다.
=SUM(QUERY('시트이름'!E1:E100,"SELECT E WHERE E IS NOT NULL",1))
REFERENCES
[Google Docs Editors Help SUM]: https://support.google.com/docs/answer/3093669?hl=en-GB&sjid=4850576250195005546-AP
SUM - Google Docs Editors Help
Returns the sum of a series of numbers and/or cells. Sample usage SUM(A2:A100) SUM(1,2,3,4,5) SUM(1,2,A2:A50) Syntax SUM(value1, [value2, ...]) value1 – The first number or range to add together. value2, ... – [ OPTIONAL ] – Additional numbers or ran
support.google.com
[Google Docs Editors Help QUERY]: https://support.google.com/docs/answer/3093343?hl=en&sjid=4850576250195005546-AP
QUERY function - Google Docs Editors Help
Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, [headers]) data - The range of cells to perform the query on. Each column of data can only h
support.google.com