working with excel worksheets, formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Type date you need to look for in A1
in B1
=VLOOKUP(A1,E1:H25,2,FALSE)+VLOOKUP(A21,E1:H25,3,FALSE)
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))
 
Back
Top