Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding cells with different quantities and pricing but displaying
Hello,
I have a spreadsheet that I maintain that add up the quantity and price of different products at different retailers. The price may change each month and I need to figure out a way to display the quantity sold in the cell but keep the price hidden so you only see the quantity sold. I also have to add up the quantity sold and price to get the total amaonut and have this ammount added up and only displayed as a total for the year. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding cells with different quantities and pricing but displaying
Have you tried making the undesired cells' texts' color formatting
white? sfmichaela wrote: Hello, I have a spreadsheet that I maintain that add up the quantity and price of different products at different retailers. The price may change each month and I need to figure out a way to display the quantity sold in the cell but keep the price hidden so you only see the quantity sold. I also have to add up the quantity sold and price to get the total amaonut and have this ammount added up and only displayed as a total for the year. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding cells with different quantities and pricing but display
I do not want the price to have its own cell, A(quantity)+B(Price)=C, i want
(A) to be shwon in the cell for each month and (C)added up at the end of each year " wrote: Have you tried making the undesired cells' texts' color formatting white? sfmichaela wrote: Hello, I have a spreadsheet that I maintain that add up the quantity and price of different products at different retailers. The price may change each month and I need to figure out a way to display the quantity sold in the cell but keep the price hidden so you only see the quantity sold. I also have to add up the quantity sold and price to get the total amaonut and have this ammount added up and only displayed as a total for the year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|