Thread: complex formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otávio Alves Ribeiro Otávio Alves Ribeiro is offline
external usenet poster
 
Posts: 20
Default complex formula

Hi there.
You may want to try:
=int(sum(A1:D12)/3)
Regards,
Otavio

"Debi" wrote:

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?