COUNTIF function not working

**RoyLittle0** · 06-29-2013, 05:04 AM

I am trying to use COUNTIF to Count all the cells above and count all the cells below the value in two another cells

I am using the formula

=COUNTIF(A1:A300,"<"&D4)
and
=COUNTIF(A1:A300,"<"&D5)

But for some reason I cant get it to work

Any one able to point me in the right direction

**etaf** · 06-29-2013, 05:38 AM

try
=COUNTIF(A1:A300,"<"&D4) + COUNTIF(A1:A300,"<"&D5)

**Marcol** · 06-29-2013, 06:24 AM

Hmm ...

There seems to be a fault/corruption in your workbook, I don't know why.

I have copied Sheet A to a clean workbook and all seems fine.

This is the correct formula for "Over Weights"

Formula:

Please Login or Register  to view this content.

[EDIT]
The problem seems to be in the worksheets A-C, I copied Sheet A to a new sheet in your workbook and all seems okay.
I have no idea why these sheets are behaving as they are ...

**RoyLittle0** · 06-29-2013, 08:14 AM

Originally Posted by Marcol

Hmm ...

There seems to be a fault/corruption in your workbook, I don't know why.

I have copied Sheet A to a clean workbook and all seems fine.

This is the correct formula for "Over Weights"

Formula:

Please Login or Register  to view this content.

[EDIT]
The problem seems to be in the worksheets A-C, I copied Sheet A to a new sheet in your workbook and all seems okay.
I have no idea why these sheets are behaving as they are ...

Thanks that seems to be the answer, I thought I was doing it right, just couldn't figure out what the problem was.