More Excel help please

Discussion in 'NZ Computing' started by Brian Tozer, Dec 3, 2003.

  1. Brian Tozer

    Brian Tozer Guest

    J.E. McGimpsey wrote:

    > Simply: Compare each cell in Sheet "Audit Report", cells C2:C2001
    > with the value in cell A4 in the sheet the formula is entered in.
    > the returned value is the sum of Sheet "Audit Report", cells
    > I2:I2001 for which the comparison with their corresponding cell in
    > column C was TRUE.



    > "Brian Tozer" <> wrote:


    >> Could some kind person please tell me in words exactly what the
    >> following formula found in cell C4 means/does?
    >> And what it may be assuming or requiring elsewhere to function
    >> correctly. In use the cell has a quantity (number of items) entered
    >> in it.
    >>
    >> =SUMIF('Audit Report'!C$2:C$2001,A4,'Audit Report'!I$2:I$2001)



    While I appreciate very much the above response to my query I am still
    unclear as to exactly what it means in practice.
    Should I post my specific queries on the possible interpretations that I
    see, or can you/anyone rephrase it hoping that the extra description will
    remove my confusion?
    Possibly including an example with data entries?

    Sorry to be a nuisance, but I am making progress in the upskilling process,
    even if it doesn't show.... :)))

    Thanks
    Brian Tozer
     
    Brian Tozer, Dec 3, 2003
    #1
    1. Advertising

  2. In article <bqlr6h$1ma$>, "Brian Tozer" <> wrote:
    (snip)
    >Sorry to be a nuisance, but I am making progress in the upskilling process,
    >even if it doesn't show.... :)))


    Suggest looking at these groups
    microsoft.public.excel
    microsoft.public.excel.misc

    for xl help. They are terrific. There are (IIRC) others more
    specialised if you need that. Well worth a look.

    HTH

    Bruce

    -----------------------------------------------------------------------
    It was so much easier to blame it on Them. It was bleakly depressing to
    think that They were Us. If it was Them, then nothing was anyone´s fault.
    If it was Us, what did that make Me ? After all, I´m one of Us. I must be.
    I´ve certainly never thought of myself as one of Them. No-one ever thinks
    of themselves as one of Them. We´re always one of Us. It´s Them that do
    the bad things. <=> Terry Pratchett. Jingo.
     
    Bruce Sinclair, Dec 4, 2003
    #2
    1. Advertising

  3. Brian Tozer

    Mr Scebe Guest

    "Brian Tozer" <> wrote in message
    news:bqlr6h$1ma$...

    > >> Could some kind person please tell me in words exactly what the
    > >> following formula found in cell C4 means/does?
    > >> And what it may be assuming or requiring elsewhere to function
    > >> correctly. In use the cell has a quantity (number of items) entered
    > >> in it.
    > >>
    > >> =SUMIF('Audit Report'!C$2:C$2001,A4,'Audit Report'!I$2:I$2001)

    >
    >
    > While I appreciate very much the above response to my query I am still
    > unclear as to exactly what it means in practice.


    Clippy isn't just a pretty face! :)

    SUMIF(range,criteria,sum_range)
    Range is the range of cells you want evaluated.
    Criteria is the criteria in the form of a number, expression, or text that
    defines which cells will be added. For example, criteria can be expressed as
    32, "32", ">32", "apples".
    Sum_range are the actual cells to sum. The cells in sum_range are summed
    only if their corresponding cells in range match the criteria. If sum_range
    is omitted, the cells in range are summed.


    In practice, this means that the spreadsheet will search the "Audit Report"
    worksheet
    cells C2 to C2001 for whatever is in the cell "A4".

    It will then add the cell contents of "I2" to "I2001" for any instances of
    "A4".

    ie: if A4 is Cat, C2 is Cat and I2 is 5. If there are no more instances of
    Cat the sum will be 5 (the number of cats in the range).

    As an added indicator if you click in the formula bar, you will see the
    formula cells change colour to whatever ranges they are depicting. You can
    then drag, stretch drop them to any location you want.

    HTH.

    --
    Mr Scebe
    Losers always whine about their 'best'.
    Winners go home and **** the prom queen".
    ~Sean Connery in "The Rock
     
    Mr Scebe, Dec 4, 2003
    #3
  4. Brian Tozer

    Brian Tozer Guest

    Mr Scebe wrote:

    > As an added indicator if you click in the formula bar, you will see
    > the formula cells change colour to whatever ranges they are
    > depicting. You can then drag, stretch drop them to any location you
    > want.


    Thanks very much for your very helpfull reply.
    Could you enlarge a little on the above comment, or tell me what I should
    look for in the Help or Google for further info on this
    aspect/operation/facility/feature.

    Brian Tozer
     
    Brian Tozer, Dec 4, 2003
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Robert
    Replies:
    5
    Views:
    1,205
    MELAD MARJI SR
    Jul 14, 2003
  2. tpg comcntr

    HELP! HELP! PLEASE, PLEASE, PLEASE

    tpg comcntr, Feb 14, 2004, in forum: Computer Support
    Replies:
    11
    Views:
    901
    michael turner
    Feb 15, 2004
  3. Martin ©¿©¬  @mandeREMOVETHIS.plus.com

    need help with Excel code please

    Martin ©¿©¬ @mandeREMOVETHIS.plus.com, Jun 6, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    424
  4. Divine
    Replies:
    0
    Views:
    412
    Divine
    Jun 12, 2006
  5. rello

    excel file password - Help Please!

    rello, Nov 10, 2004, in forum: Computer Security
    Replies:
    0
    Views:
    496
    rello
    Nov 10, 2004
Loading...

Share This Page