Ok, so what I'm wanting is to be able to show the totals of a specific number out of a list of numbers between 1 and 4 from an ever changing list.
Basically each cell in the list could be any number from 1 to 4, and I want the show the total amount of 2's in the list of 50 cells, shown in 1 cell.
Last edited by Opt1kal; 02-22-2011 at 05:53 AM.
Have you looked at COUNTIF?
e.g. =COUNTIF(A:A,2)
this counts the number of 2's in entire column A.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you, that was exactly what I needed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks