No, I know this function before, and I didn't found your message some twelve
hours before. Was it in this threed posted by You?
Yes, I want to exclude 20 and 60 in this example, and I know for '=' or
'=' options.
Thank you for the advice about third parameter of SUMIF() so now I deleted
those
Hi Miguel Ángel,
thank you for advices.
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061602.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Using COUNT()/COUNTIF()/COUNTIFS() SUM()/SUMIF()/SUMIFS() as array or
SUMPRODUCT() must be the way, but seems it is no possible.
Using INDIRECT() combined with ROW() to generate the address do the trick.
As it is an array formula, Ctrl+Shift+Enter (not only enter) after write the
formula without
Yes, this helps. Thank you!
-
Best Regards from
Pál
--
View this message in context:
http://nabble.documentfoundation.org/Searching-numbers-between-two-values-tp4061491p4061513.html
Sent from the Users mailing list archive at Nabble.com.
--
To unsubscribe e-mail to:
Brian Barker wrote
Try:
=COUNTIF('Num 1'.A1:Z99;20)-COUNTIF('Num 1'.A1:Z99;=60)
=COUNTIF('Num 2'.A1:Z99;20)-COUNTIF('Num 2'.A1:Z99;=60)
=COUNTIF('Num 3'.A1:Z99;20)-COUNTIF('Num 3'.A1:Z99;=60)
moreover, I don't know how to create fourth function.
Easy:
=J1+J3+J5
(!)
I trust this
Now I'm searching the way how to SUM those numbers ( between 20 and 60 )
finded on sheets Num1, Num2, Num 3?
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061519/BetweenTwoNumbers.ods
I uploaded the file again, because I changed it a little.
I changed it because I search
At 08:52 14/06/2013 -0700, Pedro Noname wrote:
Brian Barker wrote
Are you sure? When I try this, COUNTIF() looks only at the first
cell of your range (e.g. L1:L2), so would simply count values above
20 - wrongly including those above 60.
You are correct. I apologize.
Oh, thanks - but
I found a solution! On can see it in the following uploaded file.
BetweenTwoNumbers.ods
http://nabble.documentfoundation.org/file/n4061578/BetweenTwoNumbers.ods
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
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