"I'm playing around with an Excel spreadsheet and I cannot figure out something that I know is possible.

I want to be able to use a drop down on the left of my excel sheet that if I select "No" the equations below will not use that row of data
Yes 55 122
Yes 56 215
Yes 60 186
No 12 92
Yes 15 116
Range> 48 123


Yes 55 122
Yes 56 215
Yes 60 186
No 12 92
Yes 15 116
Range> 45 99


I've googled seemingly everything but cannot come up with an answer."

pivot table... lol
or a bunch of ifs
if you explain I'll try to help ya

This post was edited by Penguins0690 on Sep 3 2016 10:05am

its for a buddy on another forum who asked. im not sure of the details
let me see if i can ask him

This post was edited by noob_whacker on Sep 3 2016 10:19am