software

I need a formula or a macro which will count using two conditions a
range of cells. The problem i have one of the conditions is a quot;less
than or equal toquot; a time.

the formula below i have used but it gives a false count, either 0 or
counts only one of the conditions

=SUMPRODUCT((A1:A25=quot;lt;=00:03quot;)*(B1:B25=quot;AMquot;))

i have also used the 'Ctrl-shift-enter' aswel.

any ideas??--
SamGB
------------------------------------------------------------------------
SamGB's Profile: www.excelforum.com/member.php...oamp;userid=31263
View this thread: www.excelforum.com/showthread...hreadid=512601=SUMPRODUCT(--(A1:A25lt;=--quot;00:03quot;),--(B1:B25=quot;AMquot;))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;SamGBquot; gt; wrote in
message ...
gt;
gt; I need a formula or a macro which will count using two conditions a
gt; range of cells. The problem i have one of the conditions is a quot;less
gt; than or equal toquot; a time.
gt;
gt; the formula below i have used but it gives a false count, either 0 or
gt; counts only one of the conditions
gt;
gt; =SUMPRODUCT((A1:A25=quot;lt;=00:03quot;)*(B1:B25=quot;AMquot;))
gt;
gt; i have also used the 'Ctrl-shift-enter' aswel.
gt;
gt; any ideas??
gt;
gt;
gt; --
gt; SamGB
gt; ------------------------------------------------------------------------
gt; SamGB's Profile:
www.excelforum.com/member.php...oamp;userid=31263
gt; View this thread: www.excelforum.com/showthread...hreadid=512601
gt;

Excellent! works like a treat

Many Thanks
Sam--
SamGB
------------------------------------------------------------------------
SamGB's Profile: www.excelforum.com/member.php...oamp;userid=31263
View this thread: www.excelforum.com/showthread...hreadid=512601