=IF(B10:B16B18,1,COUNTIF(B10:B16,"=1"))

in this formule, im trying to check if B10 is greater then B18, then
return 1 if it is, and count 1
then i want the program to do B11, and see if it is greater then B18,
then return 1 if it is, and count 1
i want this to go on and stop after B16

but this doesnt work, the part of the equation that doesnt seem to be
allowed is the B10:B16B18

is this even possible with a IF() function? is there any sort of
while() function like in C++ or any function that would allow me to
check through all of B10 through B16 to check to see if they are
greater then B18, and if they are, count those that are bigger only
(dont count those that are smaller)


thanks!
peace!
:)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

One way, if I understand you correctly:

=COUNTIF(B10:B16,"" & B18)

I'm not sure what the other COUNTIF() in the False branch is
supposed to be doing for you.

In article ,
persian_boi wrote:

=IF(B10:B16B18,1,COUNTIF(B10:B16,"=1"))

in this formule, im trying to check if B10 is greater then B18, then
return 1 if it is, and count 1
then i want the program to do B11, and see if it is greater then B18,
then return 1 if it is, and count 1
i want this to go on and stop after B16

but this doesnt work, the part of the equation that doesnt seem to be
allowed is the B10:B16B18

is this even possible with a IF() function? is there any sort of
while() function like in C++ or any function that would allow me to
check through all of B10 through B16 to check to see if they are
greater then B18, and if they are, count those that are bigger only
(dont count those that are smaller)

wOot woOt ! :D


nice!

thanks!
peace!
:)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/