View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stretch stretch is offline
external usenet poster
 
Posts: 12
Default COUNTIF Multiple conditions

I have a worksheet were I want to count the number of times a number larger
than 0 appears in the second column 'B', but only if the month is 'May' in
the first column 'A'. I seem to have problems using multiple COUNTIF
conditions, the solution is probably easy but its driving me mad!


A B
1 May 0
2 Feb 0
3 May 15
4 March 40
5 May 50