At 21:58 14/06/2013 -0700, Csányi Pál wrote:
I found a solution!
You found it? Good! Did you find it in my
message some twelve hours before? ;^)
The function is:
=SUMIF('Num 1'.A1;">20";'Num 1'.A1)-SUMIF('Num
1'.A1;">60";'Num 1'.A1)+SUMIF('Num
2'.A1;">20";'Num 2'.A1)-SUMIF('Num
2'.A1;">60";'Num 2'.A1)+SUMIF('Num
3'.A1;">20";'Num 3'.A1)-SUMIF('Num 3'.A1;">60";'Num 3'.A1)
You seemed to want to exclude 60 (as well as 20)
from your range to be summed. If so, you need ">=60" (three times), not ">60".
Is there a simpler way to do it?
Yes, there is. If the third parameter of SUMIF()
- "SumRange" - is missing, the values found in
the first parameter - "Range" - are summed
instead. Since your third parameters are all the
same as your first parameters, you can omit
them. Oh, look: that's what I did in my earlier suggestion!
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@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