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"]
[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]
[/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