Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem on network | Excel Discussion (Misc queries) | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Need a formula for this problem | Excel Worksheet Functions |