Vlookup help

Chris Pallatto

Good morning,

I've tried to create a countif & vlookup formula without luck. I would appreciate any help!

I have linked the attendance sheets from several committees into one sheet. I would like to sum how many committees each organization is participating in (participation and return that value in the "# Committees Participating" next to each organization's name.

I'm stuck and would appreciate any help!

Best,

Chris

Paul Newcome

Try this:

=SUMIFS([% Participation]$1:[% Participation]$208, YMCA$1:YMCA$208, @cell = YMCA@row)

Chris Pallatto

Paul, thanks for submitting. That returns a sum, but not the count. I tried to change the sumifs to countifs, but the parameters are different. Any other thoughts? Thanks again.

Paul Newcome

My apologies. I read "sum" in your original post and saw the reference to the % in your screenshot.

Are you wanting to count how many times that particular YMCA is listed and has a % greater than zero?

Chris Pallatto

This worked: =COUNTIFS([% Participation]1:[% Participation]208, >0.0001, YMCA1:YMCA208, =YMCA@row)