Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup & sum totals, given a start inv.# & finish inv.#
I have a worksheet containing the total of each invoice & 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.# & a finish inv.# on a different sheet. Can anyone help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup & sum totals, given a start inv.# & finish inv.#
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:A1000=A1)*(Sheet1:A1:A1000 <=B1),Sheet1!B1:B1000) HTH -- AP "Learning the hard way" a écrit dans le message de news: ... I have a worksheet containing the total of each invoice & 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.# & a finish inv.# on a different sheet. Can anyone help me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula to lookup & sum totals, given a start inv.# & finish i
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 "Ardus Petus" wrote: 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:A1000=A1)*(Sheet1:A1:A1000 <=B1),Sheet1!B1:B1000) HTH -- AP "Learning the hard way" a écrit dans le message de news: ... I have a worksheet containing the total of each invoice & 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.# & a finish inv.# on a different sheet. Can anyone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |