Countif problem

**w0rksh0p** · 11-11-2006, 11:23 AM

heLLO all,

Please advise,

The value of E13 is 5.727 where the value will change

I use this formula and the result I got is 0
=COUNTIF('W1AAHC-061110'!E:E,"<E13")

whereas when i use this the result is 4
=COUNTIF('W1AAHC-061110'!E:E,"<5.727")

**VBA Noob** · 11-11-2006, 11:33 AM

Try

=SUMPRODUCT(--('W1AAHC-061110'!$E$1:$E$10000>0)*(--('W1AAHC-061110'!$E$1:$E$10000<E13)))

or

=COUNTIF('W1AAHC-061110'!E:E,"<"&E13)

VBA Noob

**w0rksh0p** · 11-12-2006, 10:46 AM

Thank you. Got it working

**VBA Noob** · 11-12-2006, 10:52 AM

No Problem

Glad I could help

VBA Noob

Countif problem

LinkBack

Thread Tools

Rate This Thread

Display

Countif problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions