CODEWITHSUNDEEP
excel
Kris Chick
Kris Chick

Reputation: 1

Excel - Vlookup & Countif?

I have a series of data items where I have

Date, Name of Person, Class Name, RSVP, Attended

And I am trying to create a report where I have the the # of times that a Person Attended where the RSVP is Yes.

I have this right now but it's just giving me every instance of where the value is Yes in RSVP..

A3 contains the person's name
The data is is T3:W135
The Column for RSVP is W

=IF(ISERROR(VLOOKUP($A3,'Data - Week 1'!$T$3:$W$135,1,0)),0,COUNTIF('Data - Week 1'!$W$3:$W$135,"Yes"))

Upvotes: 0

Views: 77

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use COUNTIFS():

=COUNTIFS('Data - Week 1'!$T:$T,$A3,'Data - Week 1'!$W:$W,"Yes",'Data - Week 1'!$X:$X,"Yes")

I am assuming that you have Yes/No in the Attended Column

Upvotes: 1

Related Questions