I feel like I should be able to do this with the sum feature, but I haven't been able to figure it out.
I have columns with responses coded in numbers, 1-5. I want to be able to automatically output for each column a results field or field that will tell me how many 1s, how many 2s, etc. Is there an easy way to do this?
thanks in advance for any help,
tvanhorne
Hi,
try
=countif(A1:A100,1)
Thank you! That's what I was trying to figure out.![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks