View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MarkWatson MarkWatson is offline
external usenet poster
 
Posts: 3
Default how do i count the number of times criteria appears in a worksheet

what formula should i use when i have to count the number of times a cell
criteria appears on a spreadsheet, only when another criteria is present.
ie if "1407" appears in cells L3:L450, only count each of those cells if
"1201" appears in column B for the same row