Re: SUMIF

They both work. Thans
John

"Domenic" wrote:

> 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
>
.

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)