hey guys!!! this if my first post here, so I hope I wont break any rules 
I have a biiiiiiiiiiiiig problem....... I have a very big table in which I have these columns:
file number | date of file | name of buyer | type of document | debit | credit
.... soo.... I have a whole bunch of buyers.. made a pivot table, and when I select the buyer, I have his card and the final SUM, or that is, the momentary "condition" he is in... if he has anything else that is not paid already or whatever
my problem is.... HOW can I make a sum of ALL the buyers in one place? I mean now I have to list all the buyers and manually add and calculate all the sums... Is there any way I can make excel put all unpaid claims / debits in one cell???
thank you in advance
I have a biiiiiiiiiiiiig problem....... I have a very big table in which I have these columns:
file number | date of file | name of buyer | type of document | debit | credit
.... soo.... I have a whole bunch of buyers.. made a pivot table, and when I select the buyer, I have his card and the final SUM, or that is, the momentary "condition" he is in... if he has anything else that is not paid already or whatever
my problem is.... HOW can I make a sum of ALL the buyers in one place? I mean now I have to list all the buyers and manually add and calculate all the sums... Is there any way I can make excel put all unpaid claims / debits in one cell???
thank you in advance