At 22:46 05/02/2017 +0100, Rob Jasper wrote:
I am looking for a way to use MAXIFS over the equivalent ranges in
multiple tabs. Something like:
=COUNTIF('2*'.E$2:E$200;C2)
Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004,
etc.), range E2:E200 give me the number of occurrences of the value
define in C2. Is this at all possible?
A simple workaround is to assemble copies of the relevant ranges from
multiple sheets on a single summary sheet. (After all, the value you
are trying to derive definitely relates to the data generally, not to
any specific year.) Then the function reference is simple. Instead of
simply copying values, you will want to create formulae in the
summary sheet to harvest values from the individual sheets. That way,
the values on the summary sheet will automatically update as you work
on the individual sheets.
Or you could use one sheet instead of multiple, yearly sheets in the
first place. After all, 1 January 2003 comes as soon after 31
December 2002 as 31 December 2002 did after 30 December 2002.
Contrary to the theories of some partygoers, nothing particularly
discontinuous happens to time at the new year!
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted