=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!!