Thread: formula for counting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TMF in MN TMF in MN is offline
external usenet poster
  
Posts: 12
Default formula for counting
I need a formula to count if A:A=1 and B:B<20
The value should be 2
A B
1 1 12
2 2 75
3 1 86
4 1 16

Reply With QuoteReply With Quote