IF this and IF that
 

Grrrr... Ican't figure out this extremely simple requirment...

data:

f$now f$win f$tie f$los f$power f$wratio
0.50 0.50 0.00 0.00 1.00 1.00
0.67 0.67 0.00 0.00 1.33 1.00
0.75 0.75 0.00 0.00 1.50 1.00
0.80 0.80 0.00 0.00 1.60 1.00
0.83 0.83 0.00 0.00 1.67 1.00
0.86 0.86 0.00 0.00 1.71 1.00
0.88 0.88 0.00 0.00 1.75 1.00
0.89 0.89 0.00 0.00 1.78 1.00
0.50 0.48 0.00 0.00 0.98 0.96
0.67 0.64 0.00 0.00 1.30 0.96


question I want to ask:

count number of rows where f$now= .50 AND f$tie=.50 AND f$power=.95


--
Thrain
------------------------------------------------------------------------
Thrain's Profile: http://www.excelforum.com/member.php...o&userid=29192
View this thread: http://www.excelforum.com/showthread...hreadid=490348

IF this and IF that
 

=SUMPRODUCT(--(f$now_Range=.50),--(f$tie_Range=.50),--(f$power_Range=.95))

--
Regards,

Peo Sjoblom

(No private emails please)


"Thrain" wrote in
message ...

Grrrr... Ican't figure out this extremely simple requirment...

data:

f$now f$win f$tie f$los f$power f$wratio
0.50 0.50 0.00 0.00 1.00 1.00
0.67 0.67 0.00 0.00 1.33 1.00
0.75 0.75 0.00 0.00 1.50 1.00
0.80 0.80 0.00 0.00 1.60 1.00
0.83 0.83 0.00 0.00 1.67 1.00
0.86 0.86 0.00 0.00 1.71 1.00
0.88 0.88 0.00 0.00 1.75 1.00
0.89 0.89 0.00 0.00 1.78 1.00
0.50 0.48 0.00 0.00 0.98 0.96
0.67 0.64 0.00 0.00 1.30 0.96


question I want to ask:

count number of rows where f$now= .50 AND f$tie=.50 AND f$power=.95


--
Thrain
------------------------------------------------------------------------
Thrain's Profile:
http://www.excelforum.com/member.php...o&userid=29192
View this thread: http://www.excelforum.com/showthread...hreadid=490348

IF this and IF that
 

On Fri, 2 Dec 2005 20:01:50 -0600, Thrain
wrote:


Grrrr... Ican't figure out this extremely simple requirment...

data:

f$now f$win f$tie f$los f$power f$wratio
0.50 0.50 0.00 0.00 1.00 1.00
0.67 0.67 0.00 0.00 1.33 1.00
0.75 0.75 0.00 0.00 1.50 1.00
0.80 0.80 0.00 0.00 1.60 1.00
0.83 0.83 0.00 0.00 1.67 1.00
0.86 0.86 0.00 0.00 1.71 1.00
0.88 0.88 0.00 0.00 1.75 1.00
0.89 0.89 0.00 0.00 1.78 1.00
0.50 0.48 0.00 0.00 0.98 0.96
0.67 0.64 0.00 0.00 1.30 0.96


question I want to ask:

count number of rows where f$now= .50 AND f$tie=.50 AND f$power=.95


=SUMPRODUCT((f$now=0.5)*(f$tie=0.5)*(f$power=0. 95))

Of course, I don't think you can use the '$' in a Name, so you may need to
change the names to f_now, f_tie and f_power


--ron