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.

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.

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.