Thread: COUNT IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SkyGanz
 
Posts: n/a
Default COUNT IF

I am trying to "count if" across two columns. i.e Column A has categories:
direct mail, ads, tradeshows; and column B has months: January, Feb, Mar.
etc. I need the formula that will show me a count of all "direct mail" in
"January". I can't get the "countif" formula to do it, and a pivot table is
not working either. Any suggestions? Any formulas to try