| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup If Date is equal to the Day
I have a list that contains a number for each day of the year. Column A
contains the date and column B has the corresponding number of widgets. I would like wrtie a formula that will return the year-to-date average number of widgets by day. It might appear like this: Day Avg Widgets Sun 45 Mon 215 Tue 246 Wed 302 Thu 285 Fri 177 Sat 96 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
| Vlookup to Equal Zero? | Excel Discussion (Misc queries) | |||
| sorting with RANK/VLOOKUP (problem with equal ranks) | Excel Worksheet Functions | |||
| Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
| Vlookup but also equal to and greater than? | Excel Worksheet Functions | |||
Threaded Mode
