Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have 2 columns, one showing Sales (Col B) and one showing Hours (Col A) -
This shows the Sales per Hour How can I add up the Total Sales for a given Start Time and End Time. These two values will be in two cells, say AA1 and AA2 Thus if AA1 said 9:30am and AA2 said 13:45am, what would be the formula that would give me the correct answer? Note my Hour divisions are in Qtr hour, as are my Sales values Thanks |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=SUMPRODUCT((A2:A40=AA1)*(A2:A40<=AA2)*(B2:B40))
|
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Nel post
*John* ha scritto: I have 2 columns, one showing Sales (Col B) and one showing Hours (Col A) - This shows the Sales per Hour How can I add up the Total Sales for a given Start Time and End Time. These two values will be in two cells, say AA1 and AA2 Thus if AA1 said 9:30am and AA2 said 13:45am, what would be the formula that would give me the correct answer? Note my Hour divisions are in Qtr hour, as are my Sales values Thanks Hi John, Try this: =SUMPRODUCT((A2:A1000=AA1)*(A2:A1000<=AA2)*(B2:B1 000)) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Many thanks Franz
I 've just added a post on my previous 'round up to next 15 mins' perhaps you could have a look Thanks "Franz Verga" wrote in message ... Nel post *John* ha scritto: I have 2 columns, one showing Sales (Col B) and one showing Hours (Col A) - This shows the Sales per Hour How can I add up the Total Sales for a given Start Time and End Time. These two values will be in two cells, say AA1 and AA2 Thus if AA1 said 9:30am and AA2 said 13:45am, what would be the formula that would give me the correct answer? Note my Hour divisions are in Qtr hour, as are my Sales values Thanks Hi John, Try this: =SUMPRODUCT((A2:A1000=AA1)*(A2:A1000<=AA2)*(B2:B1 000)) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Otto M. - Data Matching | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |