Thread: Countif funtion
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dot Dot is offline
external usenet poster
 
Posts: 5
Default Countif funtion

I'm trying to bring three columns together that checks for a condition of a
persons name and counts how many items were processed. I have the first
function =COUNTIF(Assignments!K2:M1669,"Brian") that's working but I don't
want it to include the blank cells only cells that have "closed". What
information am I missing? I tried including the nested argument If but keep
getting a value error.
--
Dot