COUNTIF with multiple criteria
=IF(COUNTIF(E1:E100,""""),COUNTIF(K1:K100, "NPM"))
-- Best wishes, Jim "Karen.Reedy" wrote: With the following set of data, basically what I need is COUNTIF(E46 is not null) AND K46="NPM" so that I can run it on the entire spreadsheet and get a count ONLY the cells that have data in column E and belong to a specific contractor in column K. C E J K 46 Electrical not flush E Reedy NPM I've looked through the help files in Excel and can't figure out how to tie these two together, if it can even be done. I'm an Access girl, but the way I manage this project just lends itself better to a spreadsheet. Thanks in advance - if this works, it will save me a ton of time each week at work!! |
All times are GMT +1. The time now is 09:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com