| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating revenue per month by aggregating dates
I have column headings for DATE, $RATE,UNITS PER WK,NUMBER OF WEEKS, TOTAL.
At the bottom I have cells for JAN, FEB, MAR etc. I want the month cells to automatically aggregate the total $ for that calendar month by looking for the dates in the DATE column and adding the totals from the TOTAL column. There may be multiple January dates in the date column so there will be multiple rows with January relevant totals. I need a formula to place in each MONTH cell that will generate the info I need. Help??? -- Kent In Houston |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating revenue based on accounting months | Excel Discussion (Misc queries) | |||
| Calculating Month To Date Revenue | Excel Worksheet Functions | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Calculating an Activities During Periods Of Natural Months and/or Dates | Excel Worksheet Functions | |||
Threaded Mode
