View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kev270 Kev270 is offline
external usenet poster
 
Posts: 1
Default Counting and Suming based on multiple criteria

I need to get a count based on multiple criteria. I need to count if a
certain text value occurs in a column, but only if it meets a seperate date
criteria.

I have a data entry page with a vendor column and and month column. I want
to count how many times a vendor is listed in a certain month. I have tried
Count and Count IF formulas with out luck.