/media/bill/HOWELL_BASE/System_maintenance/LibreOffice/Calc formulae - ranges in separate file.txt
www.BillHowell.ca initial 16Nov2017






****************
16Nov2017  LibreCalc formulae - references to ranges in another file
eg 0_ToDos_month_count.ods

=IF($L5+B$2+1<Today,-99,COUNTIF('file:///media/bill/howell_base/todos/0_todos.ods'#file:///media/bill/howell_base/todos/0_todos.ods,$L5+B$2))

=IF($L5+B$2+1<Today,-99,COUNTIF(#'file:///media/bill/howell_base/todos/0_todos.ods'!period_sel,$L5+B$2))













enddoc