Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using hlookup with sum/choose?
I am putting a daily sales report together. At the top of the data page is a
row for the dates (full year), #billing days per month, # billing days in the quarter, and # billing days per year. I have put a hlookup together on a seperate tab that takes an input date from the end-user and calculates the start and end billing day number. Now I am trying to figure out how to return the Month to date, quarter to date, and year to date sales numbers. Basically, I need some sort of between statement that will pickup the sales that fall between the billing dates. Any suggestions? Example: Billing day 1 2 3 4 5 6 7 8 Ref table start day: 4 Ref table end day: 7 Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using hlookup with sum/choose?
I am not sure I understand how your excel looks like. However take a look at
the "match" function. I hope this helps "Stacey" wrote: I am putting a daily sales report together. At the top of the data page is a row for the dates (full year), #billing days per month, # billing days in the quarter, and # billing days per year. I have put a hlookup together on a seperate tab that takes an input date from the end-user and calculates the start and end billing day number. Now I am trying to figure out how to return the Month to date, quarter to date, and year to date sales numbers. Basically, I need some sort of between statement that will pickup the sales that fall between the billing dates. Any suggestions? Example: Billing day 1 2 3 4 5 6 7 8 Ref table start day: 4 Ref table end day: 7 Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Which function to choose? | Excel Worksheet Functions | |||
Choose Function | Excel Discussion (Misc queries) | |||
Choose From a Range | Excel Worksheet Functions | |||
Choose. | New Users to Excel | |||
CHOOSE function | Excel Discussion (Misc queries) |