[libreoffice-users] Re: To sum only those values in a range that are between two number

csanyipal wrote
> Hi Gérard,
>
>
> Gérard Fargeot wrote
> > Hi Pal,
> >
> > 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.

So if I understand well, SUMPRODUCT in this case will summarize values of
cells in an array if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26;'O.tanácsi f.év'.Z7:Z26>=8;'O.tanácsi
f.év'.Z7:Z26<=17)

*=SUMPRODUCT(array;condition1;condition2)*

but will only count cells with the given conditions if we gives the formula:
=SUMPRODUCT('O.tanácsi f.év'.Z7:Z26>=8;'O.tanácsi f.év'.Z7:Z26<=17)

* =SUMPRODUCT(condition1;condition2)*

condition1 and condition2 are arrays too.

As one can see in the LO Help,  SUMPRODUCT multiplies corresponding elements
in the given arrays, and returns the sum of those products. 

I'm trying to understand SUMPRODUCT considering this case abowe. Is there
something more to be added to this explanation?

Thanks!
Pál

--
View this message in context: 
http://nabble.documentfoundation.org/To-sum-only-those-values-in-a-range-that-are-between-two-number-tp3616470p3616853.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@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