calculate data from another spreadsheet

[oreilly]

hello there, i've been stuck with a problem that i cannot resolve. i got a spreadsheet named 2014.
On this spreadsheet there's data from cells o3 thru o83 with numbers from 0 thru 99,99 .
On another spreadsheet, call it RECAP, i try to calculate how many cells have 0 thru 9,99 on
spreadsheet 2014. I've tried many formulas but to no success. Can you help?

 

[AlanY]

try

Book1
	A
1	11.04
2	22.45
3	79.84
4	33.65
5	34.02
6	3.65
7	6.16
8	83.4
9	89.9
10	73.44
11	28.65
12	40
13	85.14
14	22.69
15	89.62
16	66.68
17	73.01
18	27.63
19	3.89
20	40.71
Sheet8

Book1
	A
1	3
Sheet9

Cell Formulas
Range	Formula
A1	=COUNTIF(Sheet8!A1:A20,"<9.99")

 

[oreilly]

thanks Alan for your rapid response. I've tried with =countif(sheet2014!O3:O83,"<9,99") but it gives me an error "Character in a formula is not valid". I've replaced your 9.99 by 9,99 because it is how i formatted my data in O3 thru O83, but either way it gives me the error.

 

[AlanY]

Check if this work or not

=COUNTIF(Sheet8!A1;A20,"<9,99")

 

[oreilly]

sorry for the late answer. No it didn't work. i found this formula which does the work... =NB.IF('2014'.O3:O83;"<=9,99") Thanks for your suggestions.

 

[AlanY]

would you post a small sample of your data here so that we can have a look

 

[sandy666]

Nb.si() == countif()

 

[oreilly]

Nb.si() == countif()

sorry, actually the formula is this one -> =NB.SI('2014'.O3:O83;"<=9,99")

 

[kvsrinivasamurthy]

99,99 is due to format of cells. Actually it is 9999.
Try this

=COUNTIF('2014'!O3:O83,"<="&999)

 

[oreilly]

99,99 is due to format of cells. Actually it is 9999.
Try this

=COUNTIF('2014'!O3:O83,"<="&999)

yes i corrected some cell formats. And i got what i wanted with this formula =NB.SI('2014'.O3:O83;"<=9,99"). Thanks for your help and clues. Cheers