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: [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
