Quick excel question

Ripper · 27 Jun 2007 at 10:15

What formula can I use to count how many cells have a particular value, out of a group of selected cells?

I have a column in which each cell either reads Reception, 1, 2, 3, 4, 5 or 6. I want a formula to count how many cells have the value Reception, 1 and 2, 3 and 4, and 5 and 6.

LostCorpse · 27 Jun 2007 at 11:56

Code:

=IF(AND(H178="value"),1,0)

you could use the above to work out the counts and use a sum at the end.

Replace value with Reception, 1, 2, 3, 4, 5, 6

Participant · 27 Jun 2007 at 11:59

=COUNTIF(A:A,[reference to cell with variable]).

Ripper · 28 Jun 2007 at 10:34

Robbie G said:
=COUNTIF(A:A,[reference to cell with variable]).

That worked, but to save space I'm grouping some figures together, so how would I change it to count the cells which have the value 1 AND 2, for example?

Ripper · 11 Jul 2007 at 11:40

Anyone?

s-p · 11 Jul 2007 at 20:22

Ripper said:
Anyone?

Could you not do multiple COUNTIFs should you require your COUNT to include more than one value. Or do you mean each source cell may contain the values 1, 2, 3 etc...?

LostCorpse · 12 Jul 2007 at 08:51

Ripper said:
What formula can I use to count how many cells have a particular value, out of a group of selected cells?

I have a column in which each cell either reads Reception, 1, 2, 3, 4, 5 or 6. I want a formula to count how many cells have the value Reception, 1 and 2, 3 and 4, and 5 and 6.

Is your Value "1 and 2" exactly as it is in the cells?

Ripper · 12 Jul 2007 at 13:20

Doesn't matter now guys thanks, doing things a different way. I'll have another question in due course though