From text to number...

[Gavin Hyde]

Hi there,

I was wondering if anyone could tell me how I can use a drop down list to reference another spreadsheet and leave a numerical value.

For example: You have a list box that has A,B,C in the list. The list box is present in say 30 cells in a column on the first sheet, you choose B from the list and on another sheet you have a cell that counts your choice, in this case B, as 1. So if you choose B 3 times and A 4 times it will count those for you on the second sheet in a cell that represents each of the choices ie A,B,C. The purpose of which is to see how many times that selection was made...

I hope I have explained well enough... Please feel free to ask for clarification and thanks in advance for any help you can offer.

 

[Gavin Hyde]

You got it!!! That was the answer as far as I can tell... Its doing what I need it to do. I'm going to play with it a little more before I say this is a closed thread but I'll let you all know...

Thanks a ton for your help with this...

g

 

[Gavin Hyde]

Looks great!!! Thanks a million...

I only have one more question... Somehow I could see my manager asking me to make this happen with one more field, in the event that this happens would I still use SUMPRODUCT or would I have to move on to another function to incorporate a third variable?

On another note I just want to say that you people are awesome and somehow it really restores my faith in humanity when I come to a site like this and people are willing to give of their time to help someone that they don't know and can't even see for that matter...

Peace and blessings,
g

 

[Gavin Hyde]

I just answered my own question... So please help someone else don't waste any more effort on me... I meant what I said - Thank you all.