Re: Sumif problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Greg,

Try this: =SUMIF(A1:A100,"A*",B1:B100)

Regards,
KL


"GregR" <gregrivet@xxxxxxxxx> wrote in message
news:1119571030.630775.94710@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have a table where I want to sum all the values in "F", if the cells
> in "A" begin with "05". "A" actually contains account numbers, which
> are text, that the first two numbers are the fiscal year. I can't quite
> get my head around a sumif or other formula. TIA
>
> Greg
>


.

Relevant Pages

  • Re: Cell Reference
    ... > hour.I can find the cells to start and finish the range by using V&H ... > but cannot get the formula to sum them to work. ... >> Regards, ... >> Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • Re: sum, lookup, and date range
    ... since January index number will return TRUE for blank cells ... Regards, ... Peo Sjoblom ... > find the sum used for Item C for each month seperately. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Why should you never use =sum(A1+A2)?
    ... =sum() ignores cells with text in them: ... A1: ASDF ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: Average a set of figures which ignores 0 entries
    ... Note that your formula does not work if any of the cells are blank, ... Regards, ... Peo Sjoblom ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Sum & Concatenate (or similar)
    ... Basically I have two cells with the start and finished column numbers that I ... then need to sum. ... Prev by Date: ...
    (microsoft.public.excel.misc)