using a counta formula for the sum of 2 columns side by side

[theYaniac]

I am trying to use a count formula for two columns side by side. For example columns A is ST hours and column B is OT hours. I need a total count of employees found. Some will have time in A and B some will have time in A or B. I only want one employee counted per row.
A B
ST OT
2 0
2 0
2 0
0 2
0 1
2 1
0 0
0 0
0 0
0 0
based on the example the count should return (6). This is a time entry for 6 separate employees. Please help

 

[Nikunj Rastogi]

pl

I am trying to use a count formula for two columns side by side. For example columns A is ST hours and column B is OT hours. I need a total count of employees found. Some will have time in A and B some will have time in A or B. I only want one employee counted per row.
A B
ST OT
2 0
2 0
2 0
0 2
0 1
2 1
0 0
0 0
0 0
0 0
based on the example the count should return (6). This is a time entry for 6 separate employees. Please help

please send attach file . your question is not clear.

 

[Asheesh]

hi,

Not really sure if I am thinking too complicated. However, for now the below solution works

SUMPRODUCT(--(MMULT(A2:B11,{1;1})>0))

Assuming that your values are stored in range A2 to B11

And is there any reason you want to stick to counta funtion

 

[theYaniac]

here is an example of the template. I need to only count the number of direct employees that have hours charged in each job. The employees could have only straight time hours, only overtime hours, or both in each job.

 

[John Jairo V]

Hi, to all!

You can use the @Asheesh proposed formula, but you not need sumproduct (just sum is suffice, and not need CSE)

=SUM(N(MMULT(A3:B12,{1;1})>0))

And you can apply this formula in each job. Check file. Blessings!