read one colum and print another

[angel0071987]

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?

GUEST NAME	SENT?	RSVP	PARTY
A	Yes	Yes	2
B	Yes	No	1
C	Yes	Yes	2
D	Yes	No	2

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>

 

[FormR]

Hi, sounds like you want to SUMIF and not COUNTIF - for example;

=SUMIF(C:C,"Yes",D:D)