Thread: Count if in different coulme
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
osaka78 osaka78 is offline
external usenet poster
  
Posts: 25
Default Count if in different coulme
i have the following data
A B C D
1 aa 11 12 15
2 bb 15 18 20
3 aa 11 19 20
4 aa 12 20 21

how can i count how many times (aa & 11) togather in the array a1:d4 ?

Reply With QuoteReply With Quote