Countif Situation....

[Mhz]

Hi, I am trying to use the countif command to count only numbers above
zero and below 45 in a column. The Column is H5:H1000. The column contains negative
numbers that I do not want to count. Just numbers above zero but below 45.

Thanks For any Help On This.

[VBA Noob]

Hi,

Thx for changing the title.

Try

=SUMPRODUCT(--($H$5:$H$1000>0),--(H5:H1000<=45))

VBA Noob

[Mhz]

No Prob, VBAnoob.

I am still getting a count on the negative numbers with your formula.
The count is true with the negative numbers when the formula is applied as
an array.

When it is not applied as an array, there is no count for numbers between
0 (zero) and 45...

[VBA Noob]

Works for me

VBA Noob

[Mhz]

VBA, I see what is happening. The cells I have, H5:H1010, has a formula
in them that subtracts dates to give a day(s) value. The sumproduct
formula you provided me with only works if it is applied after the date
calculations.

For example: If I input a date and the results are displayed in the H cells
as days, the sumproduct formula will not update to show the count, but
only if I re-paste the formula, then it will show the correct count in the
H cells. ..Wierd?