Formula problem

can anyone tell me what is wrong with this?

=SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))

Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

Maybe should be =SUMPRODUCT(--(K2:K3790="Trx"),--(02:O3790="Yes"))?

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

Maybe should be =SUMPRODUCT(--(K2:K3790="Trx"),--(02:O3790="Yes"))?

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

Maybe should be =SUMPRODUCT(--(K2:K3790="Trx"),--(02:O3790="Yes"))?

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

Maybe should be =SUMPRODUCT(--(K2:K3790="Trx"),--(02:O3790="Yes"))?

Cheers,
A

--
We are what we repeatedly do. Excellence, therefore, is not an act, but a
habit.


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

This is an aray formula so you should do a Ctrl+Shift+Enter. If there is
still a problem, try the following (Ctrl+Shift+Enter):

=SUM(IF((K2:K3790 = "Tx")*(O2:O3790 ="Yes"),1,0))

Regards,


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

This is an aray formula so you should do a Ctrl+Shift+Enter. If there is
still a problem, try the following (Ctrl+Shift+Enter):

=SUM(IF((K2:K3790 = "Tx")*(O2:O3790 ="Yes"),1,0))

Regards,


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

This is an aray formula so you should do a Ctrl+Shift+Enter. If there is
still a problem, try the following (Ctrl+Shift+Enter):

=SUM(IF((K2:K3790 = "Tx")*(O2:O3790 ="Yes"),1,0))

Regards,


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes

Hi,

This is an aray formula so you should do a Ctrl+Shift+Enter. If there is
still a problem, try the following (Ctrl+Shift+Enter):

=SUM(IF((K2:K3790 = "Tx")*(O2:O3790 ="Yes"),1,0))

Regards,


"Mike" wrote:

> can anyone tell me what is wrong with this?
>
> =SUM(IF(K2:K3790 = "Tx",IF(O2:O3790 ="Yes",1,0),0))
>
> Worked fine yesterday, counted the number of times K=TX and O = yes