Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CountIf & multiple criteria | Excel Worksheet Functions | |||
Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
Countif Multiple Criteria | Excel Discussion (Misc queries) | |||
Help please - Countif with multiple criteria | Excel Worksheet Functions | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions |