Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
Hi,
I posted this yesterday and did not get much response. I wonder if it cannot be done. Any way please read and help me with a formula. Thank you. Ok. I will use a better example. Let's say my sheet 1 shows car sales like Honda, Ford, etc. The rows are months like Jan, Feb, etc. and the columns are dates (1-30 or 31). Of course there are many empty cells because there are dates that I did not sell any car. (To keep it simple, I sell only one car if there is any sale on a day. If I sell Honda, I put "Honda" in my cell, and Ford, "Ford," etc.) The sheet 2 shows the price of each car, and A column has car brands and column B has prices of each car. Now I would like to see how much I made at the end of each month, and would like to put each total on the cell next to the last date of each month. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
I would suggest that you change the way you record your sales. Have a
sheet organised like this: Date Make Model and so you can record the date that you sold a car together with its make and model on one row. If you sell more than one car on one particular day, you just use another row with the same date, and so on. Then in this same sheet you can have another column which brings the cost (and any other items as required) from your lookup table. You can easily produce summary tables of sales by month from this main table. Hope this helps. Pete On Dec 7, 1:33*pm, Jill wrote: Hi, I posted this yesterday and did not get much response. I wonder if it cannot be done. Any way please read and help me with a formula. Thank you. Ok. I will use a better example. Let's say my sheet 1 shows car sales like Honda, Ford, etc. The rows are months like Jan, Feb, etc. and the columns are dates (1-30 or 31). Of course there are many empty cells because there are dates that I did not sell any car. (To keep it simple, I sell only one car if there is any sale on a day. If I sell Honda, I put "Honda" in my cell, and Ford, "Ford," etc.) The sheet 2 shows the price of each car, and A column has car brands and column B has prices of each car. Now I would like to see how much I made at the end of each month, and would like to put *each total on the cell next to the last date of each month. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
Jill,
Do you ever enter more than one car type in each cell? If not then I wold recommend using a pivot table to summarise the number of cars per month and then use get pivot data value formula to insert those totals to your price sheet. "Jill" wrote: Hi, I posted this yesterday and did not get much response. I wonder if it cannot be done. Any way please read and help me with a formula. Thank you. Ok. I will use a better example. Let's say my sheet 1 shows car sales like Honda, Ford, etc. The rows are months like Jan, Feb, etc. and the columns are dates (1-30 or 31). Of course there are many empty cells because there are dates that I did not sell any car. (To keep it simple, I sell only one car if there is any sale on a day. If I sell Honda, I put "Honda" in my cell, and Ford, "Ford," etc.) The sheet 2 shows the price of each car, and A column has car brands and column B has prices of each car. Now I would like to see how much I made at the end of each month, and would like to put each total on the cell next to the last date of each month. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|