The sum of the same function that is used for a range of cells

Discussion in 'Excel Beginners' started by Drakendodertje, Sep 24, 2013.

  1. Hi all,

    With no background in excel i'm trying to create a sheet in wich we ca
    schedule the worktime from various employees for a charit

    One of the functions i'm trying to implement is to show if respectivel
    the morning, afternoon and evening are under- or overstaffed, or jus
    adequately. For example i designed a function for the morninghours to b
    read from a cell C4:


    now i need the sum of using this function seperately for differen
    cells. So i designed it like this:


    This works. But like the SUM(C4:C9) formula, i would prefer to brin
    this formula down to a range instead of inserting the function for eac
    cell seperately. I tried this:

    =SUM(IF(0,5-(C4:C9)>0;0,5-(C4:C9);0)) an

    It seemed logical to me, but apparently this doesn't work. Does somebod
    know the proper notation for a range, because this would mean it is muc
    easier for the user of the sheet to insert a new employee in the futur
    without having to alter the affected formulas himself.

    I also have a new function that reads like this:

    =IF((IF(D4-0,5)>(5/24); (5/24); D4-0,5))>0; (IF(D4-0,5>(5/24); (5/24)
    D4-0,5)); 0)

    This works also, but again i would like to use it for the range D4 to D
    in this case. I hope/think the same answer for notation applies here a
    well, but i just add it for the sake of complete info.

    Thanks so much to anyone who replies in advance,


    Drakendodertje, Sep 24, 2013
    1. Advertisements

  2. Drakendodertje

    Claus Busch Guest

    Hi Joris,

    Am Tue, 24 Sep 2013 17:39:02 +0100 schrieb Drakendodertje:
    and enter the arrayy formula with CTRL+Shift+Enter

    Claus B.
    Claus Busch, Sep 24, 2013
    1. Advertisements

  3. Hi Claus,

    Thanks for your assistance, it's much appreciated

    Your suggestion worked liked a charm. I guess this is my introduction t
    CSE-formulas :
    Drakendodertje, Sep 25, 2013
    1. Advertisements

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.