complex formula

D

Debi

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top