ExcelBanter - complex formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - complex formula (https://www.excelbanter.com/excel-worksheet-functions/250889-complex-formula.html)

Debi

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?

Otávio Alves Ribeiro

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?

All times are GMT +1. The time now is 12:29 AM.