If you try to do an artithmetic operation on a boolean TRUE or FALSE, it
will be treated as 1 or 0 respectively.

A multiply operation is therefore effectively an AND function:
=1*1 is 1 just as =AND(TRUE,TRUE) is TRUE
=1*0 is 0 just as =AND(TRUE,FALSE) is FALSE
=0*1 is 0 just as =AND(FALSE,TRUE) is FALSE
=0*0 is 0 just as =AND(FALSE,FALSE) is FALSE
--
David Biddulph

"ref at heart" wrote in message
...
Thank you T. Valko,
I thought my question was clear with the countif D1:F19 formula
I just don't understand how a " * " multiple symbol works in your formula,
yet I have never used a sumproduct function before.
Again thank you, one more step closer to my bowling spreadsheet.



"T. Valko" wrote:

a number greater than 200
=COUNTIF(D4:F19,"=200")

Try this:

=SUMPRODUCT((D4:F19=200)*(J4:J19=145))


--
Biff
Microsoft Excel MVP


"ref at heart" wrote in message
...
Hello all,
What I need to do is when the formula below finds a number greater than
200
it needs to look in the corresponding row in the J column and verify
that
it
is greater than or equal to 145.

=COUNTIF(D4:F19,"=200")

D E F J
167 203 159 176
171 199 151 177

Don't believe you need the other information ~ but just in case.
Column G = D4+E4+F4
Column H = running total of colum G
Column I = =COUNTIF(D4:F4,"0")
Column J = =ROUNDDOWN(H4/I4,0)

thank you.



.