Posts by paulmcphillimy

    Hi all,


    Really struggling to on this any help will be much appreciated.
    COLUMN A S T U V
    COMPETITOR NAME Wk1 2 3 4
    [TABLE="width: 340"]

    [tr]


    [td]

    COMP 1

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 1

    [/td]


    [td]

    X

    [/td]


    [td][/td]


    [td]

    X

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [td]

    COMP 2

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 2

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 3

    [/td]


    [td]

    X

    [/td]


    [td]

    x

    [/td]


    [td]

    x

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 3

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 4

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    COMP 4

    [/td]


    [td][/td]


    [td]

    X

    [/td]


    [td]

    X

    [/td]


    [td]

    X

    [/td]


    [/tr]


    [tr]


    [td]

    COMP 4

    [/td]


    [td]

    X

    [/td]


    [td]

    X

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]



    So in column A I have a competitor name and then in columns S,T,U,V an X when that competitor has operations (weekly, hence 4 columns, representing one calendar month)


    What I want to do is create a summary underneath to represent the number of jobs each competitor has running in that calendar month, so the summary based on above would look like this:


    COMP 1 - 1
    COMP 2 - 0
    COMP 3 - 1
    COMP 4 - 2

    I want to add a "button" at the end of a report in excel that automatically attaches the work book to outlook, automatically has subject field, and saend to pre defined set of recepients. I am using Office 2007


    I am thinking needs some VBA knowledge (which I have zero.....)


    any idiot proof instructions will be greatly appreciated.


    Regards,


    Paul

    Hi, I have an issue. I want am needing to calculate the average of numbers below ZERO, so using
    =AVERAGEIF(C17:F17,"<0") which works fine. But if there are no values below 0 returns a #DIV/0! so I need to extend formule to say if C17:F17 average is EQUAL TO OR ABOVE ZERO to enter "0"


    example of data in cells is 4 3 3 3 -1 -1 -2 -1
    so average 1.25 (days in this case) delay


    but if data is 4 3 3 3 1 1 1 1
    there is no delay, so therefore I want only to note 0 - zero avaerage delay


    Thanks for help guys