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?

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?