conditionals

I am trying to average some data in my excel spreadsheet basically it looks like: <colgroup><col><col></colgroup><tbody> 1 5 2 6 3 5 4 6 1 5 2 6 3 5 4 6 </tbody> I need to average the first set of 2-4 and then the second set and so on and so forth and I am looking for an easy...

I have written a few conditionals and the output of those functions are FALSE. I want to use that fact to write other conditionals. So, if cell 1 conditional reads FALSE, I want to write a conditional in cell 2 that uses the output FALSE in cell one. However, the FALSE output in cell 1 isn't...

Hello, This is my first post and I hope I can articulate my question well. Basically I have a spreadsheet I have to reconcile every 2 weeks. in one column on my target spreadsheet I have city stations such as: ABE ACV ORD I need information from another spreadsheet that has a column with city...

I created a formula that compares an existing list with names linked to total sessions selected from list on different sheets and once the criteria is matched the sessions are tallied in the formula cell. My initial formula would be to difficult for people to change and it's sluggish. I tried...

I want to allow a workbook reviewer to review each of three different scenarios by typing the numbers 1, 2, or 3 into a cell in order to populate a table of data from three data sets. My first instinct was to use conditionals: =if(C3=1,B2,0),if(c3=2,C2,0),if(c3=3,D2,0) While I see the logic...