Am 02.06.2012 05:47, John Sowden wrote:
Cell Reference Method (cell referenced is in parenthesis): =sumif($checks.$M$(b110):$checks.$M$(c110), etc.
That would be =SUMIF(OFFSET($Checks.$M$1 ; $B$110-1 ; 0 ; $C$110-$B$110 ; 1))That is from M1 b110-1 cells down, 0 to the right, resized to the diff between c110 and b110 and 1 column width.
-- For unsubscribe instructions e-mail to: email@example.com 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