Try the fastest and simplest way to install ONLYOFFICE

Spreadsheet: Reference another list

Any issues about docs (uploading, editing and etc.)

Spreadsheet: Reference another list

Postby horis » Mon Jun 05, 2017 8:46 am

Hello, is is possible to reference a column in another list?

For example this shoudl sum all values in a column C if the value in column A equals to the A2 in the list where this function resides...

=SUM(FILTER(POHYB!C:C,POHYB!A:A=A2))
horis
 
Posts: 2
Joined: Mon Jun 05, 2017 8:24 am

Re: Spreadsheet: Reference another list

Postby horis » Mon Jun 05, 2017 9:04 am

Ok, just rewrote it like this and worsk well!

=SUMIFS(POHYB2!C:C,POHYB2!A:A,A2)
horis
 
Posts: 2
Joined: Mon Jun 05, 2017 8:24 am

Re: Spreadsheet: Reference another list

Postby Maxim » Mon Jun 05, 2017 9:09 am

Hello horis!
OK
Maxim
 
Posts: 1011
Joined: Tue Oct 11, 2016 2:34 pm


Return to Documents

Who is online

Users browsing this forum: No registered users and 1 guest