Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
wayne
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
ufo_pilot
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulas in excel are not working Csmith Excel Worksheet Functions 3 January 12th 06 05:31 PM
Delete the formulas of webpage, copied & pasted on excel sheet Mustafa Abedin Excel Discussion (Misc queries) 1 June 19th 05 02:39 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Excel in Internet Explorer Menus quit working Phil Mullins Excel Discussion (Misc queries) 0 April 8th 05 10:15 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 05:23 PM


All times are GMT +1. The time now is 08:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"