Making a String equal to a Number
Posted by Jack on August 26, 2001 8:19 PM
I'm relatively new at excel and I can't for the life of me find this function. I want to bind a number to text, for example:
"Deliverable Goods" = $250
Now I want to be able to type in Deliverable Goods and have that string appear, but at the bottom of the screen I want to have a total of the Deliverable Goods on that page. So say I had 6 Deliverable Goods on that page, I want a Total= $1500.
Any help would be greatly appreciated, I'm about to pull out my hair's hair. I just can't find this function and I'm dead in the water without it (perhaps it doesn't exist but I'd find that extremely wierd).
In essance I want A to equal 5 (A=5) so then I can take the amount of "A"'s in a column (for example 7) and have it total 35 at the bottom of the page.