software

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,

wayneType 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))

quot;waynequot; wrote:

gt; hi,
gt;
gt; i need to set up an Excel workbook that will allow me to input my sales
gt; data; and base on that data, give me performance stats, such as pulling sales
gt; from a particular date and outputting average sale or sales conversion rate.
gt;
gt; any help is much appreciated.
gt;
gt; here's what i've got:
gt; on one worksheet i have the stats/performance summary that cover one week;
gt; on the next worksheet, i have sale invoices with dates, prices, types,
gt; quantity and client info
gt; on the third worksheet, i would like to track my commission, because each
gt; type of product has different rate of commission.
gt;
gt; the main thing is, i need to fine a formula that would select a date from a
gt; column range, base on that date sum up the sales on another column
gt;
gt; tia,
gt;
gt; wayne
gt;