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 protected]
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

Reply via email to