Sheet Summary Formula

Jenna Geist

Hello-

I am trying to get a formula to display a certain cell- Hours Available in Week when the Team Member is Jaclyn and the Week Number is 22. I keep trying the formula below:

=INDEX(COLLECT([Hours Available in Week]:[Hours Available in Week], [Team Member]:[Team Member], "Jaclyn Light", [Week Number]:[Week Number], 22), 1)

Any help getting this correct?

darkmatter

@Jenna what error message are you receiving? Is there no result displayed, or a particular error message? Is the Team Member column a text column or contact column?

Matt