Thread: complex formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debi Debi is offline
external usenet poster
 
Posts: 28
Default complex formula

I need help creating a formula. I have 4 columns and 12 rows of data. When
the number in the cell reaches multiples of 3 it creates 1 occurance. So 6
in a cell would create 2 occurances. However 4 in one column and 2 in the
second column would only create 1 occurance. I tried countif 2 but that
says that 6 is only 1 occurance. Any suggestions?