View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon S. Jon S. is offline
external usenet poster
 
Posts: 4
Default Sum multiple invoice number

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,