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
|