| 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 | |||
Linear Mode
