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,
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 |
All times are GMT +1. The time now is 01:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com