View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PLVKC PLVKC is offline
external usenet poster
 
Posts: 1
Default count filtered rows based on condition greater than forty

i need to count the number of filtered rows greater than 40 for a particular
column of data. i know we hav subtotal function, but donno how to giv a
condion?