software

I have a worksheet containing the total of each invoice amp; then that gets
divided by two and placed into two seperate columns. I would like to retrieve
the total of a given number of invoices by entering a start inv.# amp; a finish
inv.# on a different sheet. Can anyone help me?

Say in Sheet2 start inv# is in A1 and finish inv# in B1;
Say in Sheet1, inv# is in column A and inv. amount in column B

In Sheet2, enter:
=SUMPRODUCT((Sheet1:A1:A1000gt;=A1)*(Sheet1:A1:A1000 lt;=B1),Sheet1!B1:B1000)

HTH
--
AP

quot;Learning the hard wayquot; gt; a
écrit dans le message de news:
...
gt;I have a worksheet containing the total of each invoice amp; then that gets
gt; divided by two and placed into two seperate columns. I would like to
gt; retrieve
gt; the total of a given number of invoices by entering a start inv.# amp; a
gt; finish
gt; inv.# on a different sheet. Can anyone help me?
Thank you very much Ardus Petus, I have been trying to work this out for
myself a long time and always seemed to go round in circles. Works perfectly,
thanks again.
Learning the hard way

quot;Ardus Petusquot; wrote:

gt; Say in Sheet2 start inv# is in A1 and finish inv# in B1;
gt; Say in Sheet1, inv# is in column A and inv. amount in column B
gt;
gt; In Sheet2, enter:
gt; =SUMPRODUCT((Sheet1:A1:A1000gt;=A1)*(Sheet1:A1:A1000 lt;=B1),Sheet1!B1:B1000)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Learning the hard wayquot; gt; a
gt; écrit dans le message de news:
gt; ...
gt; gt;I have a worksheet containing the total of each invoice amp; then that gets
gt; gt; divided by two and placed into two seperate columns. I would like to
gt; gt; retrieve
gt; gt; the total of a given number of invoices by entering a start inv.# amp; a
gt; gt; finish
gt; gt; inv.# on a different sheet. Can anyone help me?
gt;
gt;
gt;