Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum x number of fields containing data
I'm trying to make a spreadsheet that compares month to date sales figures to
previous years. How can I reference a field that says how many business days have passed in the current month, and have THAT number of fields, containing data, total from another page? i.e. -- If this is the 6th business day of the month, how can I have the sheet to total the first 6 fields that have data from last year? (The history sheet contains blank fields for days of the month that were not business days.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
Creating a number from different fields. | Excel Worksheet Functions | |||
number of fields in the row fields in pivot table | Excel Discussion (Misc queries) | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel | |||
Addition of a number of fields | Excel Discussion (Misc queries) |