Thread: Count if with several areas/conditions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marielle Marielle is offline
external usenet poster
  
Posts: 3
Default Count if with several areas/conditions
I want to create a countif formula containing two areas and conditions, i.e.
=countif(A1:A30;"V1") AND (F1:F30;"A"). How do I write the formula to make
it work? Please help...
Reply With QuoteReply With Quote