max count of set of cells

  • Thread starter Thread starter thaddeus
  • Start date Start date
T

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
 
Hi:

Try:

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

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

Regards,

Vasant.
 
Back
Top