Excel 2007 : Sum of cells with numbers in a range

I am tallying the number of cells in two columns that have numbers within a certain range.

Formula 1 is working and Formula 2 is not. They are identical formulas (I think) and can not get a tally on the cells that fall within the criteria of question 2.

1. How many cells are greater than 1.5 but not more than.3.0?
=COUNTIF('XX''s Survey Data'!AE2:AE291,">1.5")-COUNTIF('XX''s Survey Data'!AE2:AE291,"<=3.0")+COUNTIF('XX''s Survey Data'!BC2:BC291,">1.5")-COUNTIF('XX''s Survey Data'!BC2:BC291,"<=3.0")

2. How many cells are greater than 3 but not more than 5.0?
=COUNTIF('XX''s Survey Data'!AE2:AE291,">3.0")-COUNTIF('XX''s Survey Data'!AE2:AE291,"<=5.0")+COUNTIF('XX''s Survey Data'!BC2:BC291,">3.0")-COUNTIF('XX''s Survey Data'!BC2:BC291,"<=5.0")

The second formula gives a negative number (-7) as the result
Please correct me for improper posting or misinformation. I have gathered plenty from the forums but this is my first post. Many thanks in advance.

Are you using XL2007 or XL2003:

In both versions:

=COUNTIF('XX''s Survey Data'!AE2:AE291,">1.5")-COUNTIF('XX''s Survey Data'!AE2:AE291,">3.0")+(COUNTIF('XX''s Survey Data'!BC2:BC291,">1.5")-COUNTIF('XX''s Survey Data'!BC2:BC291,">3.0"))

and

=COUNTIF('XX''s Survey Data'!AE2:AE291,">3.0")-COUNTIF('XX''s Survey Data'!AE2:AE291,">5.0")+(COUNTIF('XX''s Survey Data'!BC2:BC291,">3.0")-COUNTIF('XX''s Survey Data'!BC2:BC291,">5.0"))

In XL2007 and later...

=COUNTIFS('XX''s Survey Data'!AE2:AE291,">1.5",'XX''s Survey Data'!AE2:AE291,"<=3.0")+COUNTIFS('XX''s Survey Data'!BC2:BC291,">1.5",'XX''s Survey Data'!BC2:BC291,"<=3.0")

and

=COUNTIFS('XX''s Survey Data'!AE2:AE291,">3.0",'XX''s Survey Data'!AE2:AE291,"<=5.0")+COUNTIFS('XX''s Survey Data'!BC2:BC291,">3.0",'XX''s Survey Data'!BC2:BC291,"<=5.0")