working with excel worksheets, formulas
 

hi,

i need to set up an Excel workbook that will allow me to input my sales
data; and base on that data, give me performance stats, such as pulling sales
from a particular date and outputting average sale or sales conversion rate.

any help is much appreciated.

here's what i've got:
on one worksheet i have the stats/performance summary that cover one week;
on the next worksheet, i have sale invoices with dates, prices, types,
quantity and client info
on the third worksheet, i would like to track my commission, because each
type of product has different rate of commission.

the main thing is, i need to fine a formula that would select a date from a
column range, base on that date sum up the sales on another column

tia,

wayne

working with excel worksheets, formulas
 

Type date you need to look for in A1
in B1
=VLOOKUP(A1,E1:H25,2,FALSE)+VLOOKUP(A21,E1:H25,3,F ALSE)
fill in arguments that apply to your woorksheet.
FALSE is when the dates are not sorted
TRUE would be for a sorted column of dates

=VLOOKUP($A$1,DateColumn,ColumnToReadFfrom,FALSE)+ (VLOOKUP($A$1,DateColumn,ColumnToReadFrom,FALSE))

"wayne" wrote:

hi,

i need to set up an Excel workbook that will allow me to input my sales
data; and base on that data, give me performance stats, such as pulling sales
from a particular date and outputting average sale or sales conversion rate.

any help is much appreciated.

here's what i've got:
on one worksheet i have the stats/performance summary that cover one week;
on the next worksheet, i have sale invoices with dates, prices, types,
quantity and client info
on the third worksheet, i would like to track my commission, because each
type of product has different rate of commission.

the main thing is, i need to fine a formula that would select a date from a
column range, base on that date sum up the sales on another column

tia,

wayne