Finding specific columns and counting in them

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!