Thread: Countifs function equivalent for Excel 2002 (XP)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Task Database Nightmare Task Database Nightmare is offline
external usenet poster
  
Posts: 1
Default Countifs function equivalent for Excel 2002 (XP)
I need the functionality of COUNTIFS but for Excel 2002. I don't want to sum
but rather count. Below is the formula I would use if I had the COUNTIFS
function.

=COUNTIFS(A3:A7764,"PGA",J3:J7764,"x")

Any suggestions?
Reply With QuoteReply With Quote