Add Column Data with Twist

[John]

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

 

[Guest]

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

 

[Franz Verga]

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:B1000))


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[John]

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