View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amy Amy is offline
external usenet poster
 
Posts: 165
Default count pieces of records meet conditions in different columns

Say I have a Spreadsheet with 3 columns, and they are, Age, Gender, Location.
Then how could I count how many pieces of records there are matching certain
age, gender and location?

I know how to use SQL to get the data and numbers. But I would like to how
to use Fuctions such as COUNTIF, but I can't figure it out. it's very
frustrated.