making a sum total

[Abhishek kedia]

I need a solution for one of the problem in excel. I will let u understand my
problme with an example

" suppose I have a list of invoice no. in coloum "A" and value of those
invoices in column "B". I have received a single payment against some of
those invoices. I want to match that particular payment against the invoices
for which I have received payments as mentioned here

A B

X 1
Y 2
Z 3
AA 4
AB 5
CD 6

Suppose I have recd a payment of Rs 7.00. I want those invoices which have
sum total of Rs. 7.00

I think u have got my idea.

Pls help me out

Abhishek kedia
+919312287369

 

[robert111]

If company A has outstanding invoices of 2,3,4,2,3,5

and they send you a payment of 7

this could be
2 and 5
the other 2 and 5
3 and 4
the other 3 and 4
2, 2 and 3
2, 2 and the other 3

you really need to know which invoices are being paid.

BUT if you and your customers are happy to find any invoices that total
to the payment received and mark them as paid, it might be possible, eg
you would presumably choose the oldest invoices to clear if there was a
choice. Please clarify.

 

[Abhishek kedia]

Hello Mr. Robert

Thanx for the suggestion
but I think u hv not got the problem
Example of invoice is just for understanding
the actual problem for which I need the solution is

"is there any command by which I can get those values out of a particular
list, which has some specific sum total

like

1
2
3
4
5
6
7

I need to know what r those values out of 1 to 7, which has sum total of 8

I think u hv got me

Abhishek kedia,India
919312287269