Re: SUMIF

From: Domenic <domenic22@xxxxxxxxxxxx>
Date: Thu, 30 Jun 2005 20:13:39 -0400

Try...

=SUMPRODUCT(--(ISNUMBER(RIGHT(A2:A5)+0)),B2:B5)

Hope this helps!

In article <65C7CC03-A7ED-4D0E-BAC1-F9B6125BBECA@xxxxxxxxxxxxx>,
"john the confused" <john the confused@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:

> What I have is a list in column a of invoice numbers that either end in a
> letter or a number & what I need to do is add up the invoice values from
> column B for all the invoices that have a number at the end of them in column
> A
> ie
> Cell A1 Invoice, B1 Amount
> A2 "aaa111", B2 Â£100
> A3 "bbb222", B3 Â£200
> A4 "xxxxxx", B4 Â£150
> A5 "zzzzzz", B5 Â£300
> So I want to have the sum of B2 & B3 as these have invoicce numbers ending
> in a number.
>
> Any thoughts on doing this?
>
> John
.

Follow-Ups:
- Re: SUMIF
  - From: john the confused

References:
- SUMIF
  - From: john the confused

Prev by Date: Re: Text in Formula bar displays vertical in Excel, How?
Next by Date: How do you work with drop down list to show a name, diff payment?
Previous by thread: Re: SUMIF
Next by thread: Re: SUMIF
Index(es):
- Date
- Thread

Relevant Pages

RE: Vook up help required
... "Ali Noor" wrote: ... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
(microsoft.public.excel.worksheet.functions)
Re: formsof (inflectional, "")
... I've already looked at all of the options John has suggested. ... The catalog dump will provide you with ... > "Hilary Cotter" wrote in message ... So when the user types in invoice; ...
(microsoft.public.sqlserver.fulltext)
RE: Vook up help required
... "John C" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ... column is equal to 1234 (or whatever cell reference you are using), ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... "John C" wrote: ... "Ali Noor" wrote: ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ...
(microsoft.public.excel.worksheet.functions)
RE: Vook up help required
... that's not how your original question was posted. ... You have ALL invoice numbers in column A, you have some value in column B, ... The coulmn 1 Invoice Numbers has to be macthed with All the Invice Numbers ... "John C" wrote: ...
(microsoft.public.excel.worksheet.functions)