Help with Formula

[Jill]

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.

 

[Pete_UK]

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

 

[Irishrich]

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.