| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i sum vales of sales falling between certain time periods
in column A is list of dates populated each day of the year from jan 1st to
dec 31st. And In column b i have the sales $ for that day. there is more than 1 sales entry for each day, hence multiple entries using the same date. How do i have a summary table that shows only total sales between certain time periods. eg march, or may Eg, only sales from Column B, matching the date in colum A between 1-mar-05 and 31-mar05. I was thinking: TO SUM SALES VALUES FROM COLUMN H1:H365 ONLY IF(A1:A365, = 1 MAR 05 AND <=31 MAR 05 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
| Formula help in a monthly sales report. | Excel Worksheet Functions | |||
| Help with sales chart | Charts and Charting in Excel | |||
| Complex Sales Tax | Excel Worksheet Functions | |||
| Help with Commission forumlas | Excel Worksheet Functions | |||
Threaded Mode
