RSVP List -- Counting y,n,m and blank

[meppwc]

I am using a spreadsheet to keep track of invitations to a party. One column is reserved for RSVP's. Those columns contain a y, n, m or is blank (people who have not contacted us to state if they are attending or not.

I want to be able to tally the amount of y, n, m and blanks.

Anyone have any idea how to do this

 

[Andrew Poulsom]

Use these formulas:

=COUNTIF(A1:A10,"y")
=COUNTIF(A1:A10,"n")
=COUNTIF(A1:A10,"m")
=COUNTBLANK(A1:A10)

where A1:A10 contains the list of replies.

 

[Northerner]

people coming {=SUM((A1:A10)*(B1:B10="Y"))}
(Array CNTRL+SHIFT+ENTER)

not coming {=SUM((A1:A10)*(B1:B10="N"))}
(Array CNTRL+SHIFT+ENTER)

 

[Aladin Akyurek]

What follows is a reply to your locked topic [ http://www.mrexcel.com/board2/viewtopic.php?t=51298] ...

Book3
	A	B	C	D
1	Name	Count	RSVP
2	Mike	2	y
3	Terry	3	n
4	Beth	1	m
5	Mom	2
6	Keith	4	y
7	Total	12
8	AfterRSPV	9
9
Sheet1

The formula is...

=SUM(SUMIF($C$2:$C$6,{"y","n"},$B$2:$B$6))

Is this what you're looking for?

 

[meppwc]

That is what I was looking for, thanks a million

 

[meppwc]

I just noticed something. The "n" is being added as opposed to subtracted from the total. In you example provided above, Cell A8 "After RSVP" should total out to be 6. Currently it is 9 (because the 3 "n" is being added opposed to subtracted)

 

[Aladin Akyurek]

I just noticed something. The "n" is being added as opposed to subtracted from the total. In you example provided above, Cell A8 "After RSVP" should total out to be 6. Currently it is 9 (because the 3 "n" is being added opposed to subtracted)

No problem. A simpler SumIf formula will suffice...

=SUMIF($C$2:$C$6,"y",$B$2:$B$6)

 

[lenze]

Why not a PIVOT TABLE??

Book1
	A	B	C	D	E	F
1	Name	Count	RSVP		SumofCount
2	Mike	2	y		RSVP	Total
3	Terry	3	n		m	1
4	Beth	1	m		n	3
5	Mom	2			y	6
6	Keith	4	y		NoResponse	2
7					GrandTotal	12
8
Sheet1

 

[meppwc]

i should have been able to see that.....thanks again