Sum multiple invoice number

[Jon S.]

I'm running a simple sheet where i have invoice numbers running down column
A, and dollar amounts for that invoice running down column E. I can vlookup
any invoice number and get the amount for that invoice, but I'd like to type
in 2,3 or 4 invoice numbers into 1 cell and have it return a sum for all of
those invoices.

Any ideas? I can't imagine that this is uncommon.

Thanks,

 

[Max]

Type your multiple invoice numbers into F2:F10

Then you could sum it up with this,
In say, G2:
=SUMPRODUCT(ISNUMBER(MATCH(A2:A200,F2:F10,0))*E2:E200)
Adapt to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik

 

[Jon S.]

The equation works great. One last bit though. Any way to put invoice
numbes in the same cell? Rather than summing invoices
23
25
27

I'd like to sum invoices 23, 25, 27


Thanks, Jon

 

[Max]

The equation works great.
That's good. Take a moment to press the "Yes" button in that response

Any way to put invoice numbers in the same cell?

It's tough to do it this way. I'd refrain from having mixed/multiple data
entry into the same cell. Maybe other responders would spare you some of
their thoughts.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,700 Files:353 Subscribers:53
xdemechanik
---

 

[Jon S.]

Ok Max. Now it's working well. but i still would like to put multiple
numbers in a cell. I want to look up a series of invoices and easily compare
them to another series of invoices. and i'll be doing this to make sure i
haven't missed any invoices, and that several invoices are being paid as one.


Anyway.

I like the formula, but some times it's just 1 invoice, mostly it will be 2
or 3 invoices. so that means each calculation has varying number of rows.
Which doesn't work for me.

What can be done to read three numbers from one cell instead of 3 cells?

 

[Jon S.]

nothing? else from anyone here?

Ok Max. Now it's working well. but i still would like to put multiple
numbers in a cell. I want to look up a series of invoices and easily compare
them to another series of invoices. and i'll be doing this to make sure i
haven't missed any invoices, and that several invoices are being paid as one.


Anyway.

I like the formula, but some times it's just 1 invoice, mostly it will be 2
or 3 invoices. so that means each calculation has varying number of rows.
Which doesn't work for me.

What can be done to read three numbers from one cell instead of 3 cells?

 

[Max]

Suggest that you put in as a fresh new post for your query. That'll make it
easily visible to other responders, for improved chances of responses. I've
nothing further to offer you here.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik