Finding specific columns and counting in them

  • Hi,


    I would need to count number of specific entries between two columns.
    I have columns with different dates in first row:
    [TABLE="width: 653"]

    [tr]


    [TD="class: xl71, width: 85, align: right"]06.01.2017[/TD]
    [TD="class: xl71, width: 85, align: right"]04.01.2017[/TD]
    [TD="class: xl71, width: 95, align: right"]03.01.2017[/TD]
    [TD="class: xl71, width: 88, align: right"]29.12.2016[/TD]
    [TD="class: xl71, width: 109, align: right"]28.12.2016[/TD]
    [TD="class: xl71, width: 103, align: right"]22.12.2016[/TD]
    [TD="class: xl71, width: 88, align: right"]20.12.2016[/TD]

    [/tr]


    [/TABLE]


    there are different values in the columns (e.g. sms or mail)


    Then I have defined weeks, e.g. 26.12.2016 to 30.12.2016


    I would like to count number of word "sms" in the columns where dates fall between above range. In this case this are only two columns (28.12.2016 and 29.12.2016).
    If possible I would also like to define rows, so that it counts only from 1 to 1128 row.


    Is there any way to do this?
    Thank you

  • Re: Finding specific columns and counting in them


    The SUMPRODUCT function can do this for you, or you can use the COUNTIF function; however without knowing the layout of your data, I can offer no specific solution.

    Kieran

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!