complex formula

  • Follow


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?
0
Reply Utf 12/12/2009 9:38:01 PM

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?
0
Reply Utf 12/12/2009 10:40:01 PM


1 Replies
207 Views

(page loaded in 0.048 seconds)

Similiar Articles:
















7/28/2012 12:41:33 AM


Reply: