Totaling selected cells
Hi all,
I have a range of data which displays oustanding invoices. These invoices are over a range of clients and in no particular order. I have a table at the bottom which splits out this data by client. What i am trying to do is create a formula which looks in the range specified and returns the total amount outstanding per client. The closest I have got is thus: =sum(vlookup("Littlewoods",$D:$6:$J$826,6,0)), but this just shows the number of "littlewoods" amount cells in the range, if i could somehow show the cash value of those 44 cells, I would be a happy man. Currently i am using =sum(~) and manually selecting the cells using the auto filter function, its laborious and time consuming, hence my question. Many thanks in advance, Rikki Belsham |
Totaling selected cells
hi.
have you considered the sumif function? you did mention data layout so for example if client name was in column a and invoice amout was in column b. =sumif(A2:A500,"Littlewoods"),B2:B500) you would need a sumif for each client. perhaps create a summery column to show amount due by client then sum the sumif's for total amount due. Regards FSt1 "Chiccada" wrote: Hi all, I have a range of data which displays oustanding invoices. These invoices are over a range of clients and in no particular order. I have a table at the bottom which splits out this data by client. What i am trying to do is create a formula which looks in the range specified and returns the total amount outstanding per client. The closest I have got is thus: =sum(vlookup("Littlewoods",$D:$6:$J$826,6,0)), but this just shows the number of "littlewoods" amount cells in the range, if i could somehow show the cash value of those 44 cells, I would be a happy man. Currently i am using =sum(~) and manually selecting the cells using the auto filter function, its laborious and time consuming, hence my question. Many thanks in advance, Rikki Belsham |
Totaling selected cells
Perfect, I knew it could be done!!!!!!
Thanks alot. "FSt1" wrote: hi. have you considered the sumif function? you did mention data layout so for example if client name was in column a and invoice amout was in column b. =sumif(A2:A500,"Littlewoods"),B2:B500) you would need a sumif for each client. perhaps create a summery column to show amount due by client then sum the sumif's for total amount due. Regards FSt1 "Chiccada" wrote: Hi all, I have a range of data which displays oustanding invoices. These invoices are over a range of clients and in no particular order. I have a table at the bottom which splits out this data by client. What i am trying to do is create a formula which looks in the range specified and returns the total amount outstanding per client. The closest I have got is thus: =sum(vlookup("Littlewoods",$D:$6:$J$826,6,0)), but this just shows the number of "littlewoods" amount cells in the range, if i could somehow show the cash value of those 44 cells, I would be a happy man. Currently i am using =sum(~) and manually selecting the cells using the auto filter function, its laborious and time consuming, hence my question. Many thanks in advance, Rikki Belsham |
All times are GMT +1. The time now is 02:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com