using libreoffice collate data from multiple tabs - INDEX, MATCH and SUMIFS formulas

Опубликовано: 31 Октябрь 2024
на канале: A Forum
129
2

using libreoffice and collating data from multiple sheets. using INDEX and MATCH formulas if you need an alternative to vlookup. And using SUMIFS to sum values that are within a date range.

useful links
Listing all tabs
https://ask.libreoffice.org/t/is-ther...

Sum between dates
https://ask.libreoffice.org/t/solved-...

Return value left of lookup
http://www.excel-university.com/how-t...

thankyou for watchig

0:00 Introduction
2:08 using Navigator menu
4:08 INDEX and MATCH formulas
12:28 SUMIFS formula
15:59 thankyou for watching