Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas in excel are not working | Excel Worksheet Functions | |||
Delete the formulas of webpage, copied & pasted on excel sheet | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel in Internet Explorer Menus quit working | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) |