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)
--
View this message in context:
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616564.html
Sent from the Users mailing list archive at Nabble.com.
--
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
