max count of set of cells

[thaddeus]

Hi, I am trying to limit the count of two sets of cells,

example: e14 counts the amount of entries in cells a1
through a7 and c1 through c7.

this works fine, but, i want to limit the count to "7" so
that even if all the above listed cells have entries the
count in e14 will be "7" instead of "16"

thanks for any help

Thaddeus

 

[Vasant Nanavati]

Hi:

Try:

=MIN(COUNT(A1:A7,C1:C7),7)

Not sure how the maximum count could be 16, though! <g>

Regards,

Vasant.