Formula: to count cells and then add number.

Solved/Closed
Stormdronk - Jun 13, 2011 at 02:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2011 at 09:56 AM
Hello, All

Hope you can help!

I have a list of actions

1 Contacts
2 Appointments
3 Estimates
4 Sales

contacts counts as 1 contact, appointments counts as 1 contact and 1 appointment, estimate, 1 cont 1 app and one estimate. The sales count as 1 cont 1 app 1 estimate and ons sale.

What I would like to do, lets say, if I count all the 2s in coulm a, then in cell b1 b2 it must show one cont and 1 appointment, and so on if I count all the 3 in coulm a then b1, b2 and b3 will all have a 1 in them.

Hope this is clear, thanks in advance!!!!
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 13, 2011 at 11:03 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site or http://wikisend.com/
post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0
Hi Rivisa

I solved the problem by having hiden cells count my data and then suming them to my result cells. Not the fasted way but it worked.

Thanks again!!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 14, 2011 at 09:56 AM
thanks for you feedback.
Have a good day
0