Subtracting AD and/or BC dates

[Luciano]

Hi Claus,
Yes, but I believe that it is a good approximation. Now I have a new "problem" to solve that is look for a specific sum of values in a column that match a specific criterium. For example: Look for the situations for which thevalue is 30 and type this value in an adjacent column:
5.0
18.0
12.0 30.0
11.0
6.0
1.0
11.0
24.0
11.0
6.0
6.0
12.0
6.0 30.0
5.0
12.0


Em sábado, 20 de julho de 2013 06h22min51s UTC-3, Claus Busch escreveu:

 

[Claus Busch]

Hi Luciano,

Am Sat, 20 Jul 2013 14:34:11 -0700 (PDT) schrieb Luciano:

5.0
18.0
12.0 30.0
11.0
6.0
1.0
11.0
24.0
11.0
6.0
6.0
12.0
6.0 30.0
5.0
12.0

if you want to sum A:A with criteria in B:B is 30 then try:
=SUMIF(B1:B1000,30,A1:A1000)
If you want to find all values in A:A if criteria in B:B is 30 then try:
=IFERROR(INDEX($A$1:$A$1000,SMALL(IF(B$1:B$1000=30,ROW($1:$1000)),ROW(A1))),"")
and enter the array formula with CTRL+Shift+Enter and copy down.


Regards
Claus B.