Counting Blank in each row

[Anonymous]

Hi,

I have a data as per below,

A,B & C are the salesman & 01/05   02/05   03/05  are dates

As per data, A worked for 02 days, B for 01 day & C for all 03 days

I want to create a new column "working days" here, How to do that.

      01/05   02/05   03/05   Working Days

A     10         12                      2

B                             11           1

C    13           12        15         3

Regards,

Ashraf

[Mariusz]

Hi @Anonymous 

Can you provide a data sample?

Thanks

Mariusz

[Anonymous]

@Mariusz  Could you please check now

@Anonymous  not working

[Anonymous]

Hi ,

Please see below,

I want to get the values of working days column(Where there is blank in sales column, it means salesman didnt working on that day.

Thanks..

[Anonymous]

@Anonymous Please try below solution and check if it works

1. Go to edit query

2. Select all the column in among which you want to find non blank values

3. Click on add column tab

4. Click on statistics and select count values option