angel0071987
New Member
- Joined
- Apr 11, 2016
- Messages
- 2
Hi so i have a sheet that i want to add a cell that can tell me the exact number of people attending.
I can get it to tell me how many have said yes or no by using the COUNTIF(C:C,"Yes") but i want to be able to get the actual number of people coming. Ie to read if the RSVP column is yes and then return the total number of guests coming - in this case 4...
Is this possible?
[TABLE="width: 296"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]GUEST NAME[/TD]
[TD]SENT?[/TD]
[TD]RSVP[/TD]
[TD]PARTY[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]
I can get it to tell me how many have said yes or no by using the COUNTIF(C:C,"Yes") but i want to be able to get the actual number of people coming. Ie to read if the RSVP column is yes and then return the total number of guests coming - in this case 4...
Is this possible?
[TABLE="width: 296"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]GUEST NAME[/TD]
[TD]SENT?[/TD]
[TD]RSVP[/TD]
[TD]PARTY[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]