Hi, 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? -- To unsubscribe e-mail to: users+unsubscribe@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