Originally Posted by Tark
but that wouldnt count anything. The final anser would be 1 or 0 right?
:wtc:
no, it'll work. the reason you have to do the ctrl shft enter to make the {} is because it's an array. it'll perform that function on the entire range. so in the end you'll get a bunch of 0s and 1s which will be summed for you conveniently in a single cell.