Formula problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula assistance column match sum 3
Can I use an array formula with multiple criteria in the same row? 8
Baffeling IF statement 7
Array Formulas with multiple criteria in the same row? 6
Function 4
Formula Problem 3
Check for NON-presence of a string in another string 3
Conditional formatting Formula using AND 4

Back
Top