Dagonini wrote:
I have a formula that I am using to transfer data from one spread sheet
to another.
=IF(Sheet1!AU2:AU11 =45,(COUNTIF(Sheet1!AU2:AU11,"<=49")),"")

AU 1 through 11 looks like this:

0
37
47
57
67
27
37
37
37
37
37

I am asking the formula to count how many are between 45 & 49. The
answer keeps telling me 8. But it should be 1. What am I doing wrong?

Does the second half of the if statement not just return the number of
cells less than or equal to 49?