Add Column Data with Twist

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

=SUMPRODUCT((A2:A40>=AA1)*(A2:A40<=AA2)*(B2:B40))

Nel post news:e7jt48$b5j$1@reader01.news.esat.net
*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:B1000))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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" <fra68ve@InVento.it> wrote in message
news:%23qjHIO8lGHA.3632@TK2MSFTNGP03.phx.gbl...
> Nel post news:e7jt48$b5j$1@reader01.news.esat.net
> *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:B1000))
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>