I'm trying to count the numbers of 1s, 2s, and 3, in particular cells.

The values are in cells in the same column, however there is data between these cells, so I can't say somethiing like =countif(C2:C240,"1")

It has to be somelike like =countif(C2,C6,C10,C14,C19,C37,C42,C98,"1")

^^^but the above clearly doesn't work.

The cells are all over the place.

Ideas?

 

I'm lost

 

It should still count the number of 1's even if there is other data in other cells.

 

I would quit that job and take the new one.

 

Unless there are 1's in the other cells that aren't related to what he's counting?

Just set up another column which contains only the selected cells you want and run your count formula then

 

^^^^^^^^

I would set up another column, but the spreadsheet can't be altered easily. This is a pretty complex model and a genius manager has decided she wants a count of some data points. I'm sensing we're fucked... I haven't found any way to do this easily...

 

Whats wrong with your example?

If you know which cells have the 1s, 2s, and 3s you can do...

=sum(c2,c6,c10...) for 1s
=sum(c3,c5,c11...) / 2 for 2s
=sum(c4,c7,c12...) / 3 for 3s

This would work only if 1s, 2s and 3s are not interchangeable in the same cells of coarse.

 

werd.

copy the cells the you want into a new spreadsheet (paste special - values)...then do your count there.

or copy the whole column to another spreadsheet and do it that way.

i think we need more info on your limitations...

 

If he could easily tell which ones had 1s and 2s he wouldn't need the count function

 

]

 

shut up

 

Is this the same guy who asked an Excel question and pissed everyone who tried to help?? Doesn't sound like it but just wondering.

 

Do all the count functions in excel work for continuous ranges?

 

the problem is the comma separator makes the formula think you're into the criteria when you're still setting the range - not sure how to fix it.

You sure you can't do the whole range? What's between the cells?

 

Are the cells you want to count evenly spaced?

 

Dude, you were right the first time.

=countif(range,criteria)
=COUNTIF(B2:B28,1)
=COUNTIF(B2:B28,2)
=COUNTIF(B2:B28,3)...etc

1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3
4
1
2
3


7
7
7
6

 

www.readthefuckingoriginalpost.com