Can Formulas be used with Combo Boxes?

[Lori]

Hello,

I have a worksheets that I need to tally information
provided in a combo box to a summary sheet. Is this
possible to tally that information in the combo boxes
with a countif formual?

Thanks so much ~Lori

 

[Kostis Vezerides]

Hi Lori,
Assuming your combo boxe's input range is in A1:A10, the
cell link is in B1, then in C1 you can put the formula
=INDEX(A1:A10, B1), which will place in C1 the requested
label.

You can then use =COUNTIF(range, C1).

HTH
Kostis Vezerides

 

[Guest]

Hello Kostis,

The combo boxes input range in in a separate spreadsheet
from where the combo boxes are. I am not clear on what
you mean by 'the cell link is in B1'. Could you please
clarify? Thanks so much!
~Lori

 

[Lori]

My input range is B1:B3, and the cell link is left blank,
where do I go from here?

Thanks,
Lori

 

[Kostis Vezerides]

Lori,
when you Ctrl+click the combo box to make it the active
object, you then double-click it to bring up the format
dialog box. You must specify the input range and the cell
link. The first contains the list of values that are to
appear in the combo box. The second is the output of the
combo box and is a number from 1 to the length of the
input range.

If you have specified these properties the cell link
should not be left blank. Did you? If you did, come up
with more details.

Kostis