Hi Gérard,
Gérard Fargeot wrote > > Hi Pal, > > > >> I'm trying with this formula: >> {=SUMIF('O.tanácsi f.év'.Y7:Y26;AND('O.tanácsi >> f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384))} >> > > Did you forget the "magic" function SUMPRODUCT ? > > =SUMPRODUCT('O.tanácsi f.év'.Y7:Y26;'O.tanácsi > f.év'.Y7:Y26>25;'O.tanácsif.év'.Y7:Y26<=384) > > Gérard (again) > No, I didn't forget it, but it seems that that I didn't understand it well. Sorry. Thanks again, Gérard! -- View this message in context: http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616606.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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