Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look up problem
I am using a lookup to have a user enter a part number in one cell and have
the lookup place a price in another cell. the problem i am having is I want to be able to use the price it puts in an auto sum to calculate total price but it wont do it because the formula is what is in the cell insted of the price???? is there an easier way to do what i want. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Look up problem
Hi Delton,
Have you tried this? The sum of formula cells is normally the sum of the returned formula values. --- Regards, Norman "Delton" wrote in message ... I am using a lookup to have a user enter a part number in one cell and have the lookup place a price in another cell. the problem i am having is I want to be able to use the price it puts in an auto sum to calculate total price but it wont do it because the formula is what is in the cell insted of the price???? is there an easier way to do what i want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |