adjacent cells

Hi all, I am trying to average 2 cells (k35 and m35) if the cell value is greater than 0. Those 2 cells are an average of the column. I want the equation to average both cells if there is a value in the cells, if not, just display one or the other cell value. The issue that I am running into...

Hi my data is setup as follows: <tbody> 1/7 1/7# 1/8 1/8# 1/9 1/9# 1/10 1/10# chihuahua red 8 red 7 blue 3 red 6 bulldog green 1 red 4 red 9 blue 1 mutt blue 8 blue 1 green 1 red 3 </tbody> I am trying to find out for ie. row 2(chihuahua), I need the average of...

All, I'm working on a portion of a spreadsheet where I'm trying to minimize the amount of input the user has to do. I would like a few cells to use the info in one cell (the Quote #) and return a variety of information. The user inputs the quote number. I want the name and territory to fill...

I'm getting all twisted up in my logic for the following situation, or maybe this can't be done with a simple formula.... Thank you! In B3, add +1 for each year up to 5 that company has had sales and they have not declined; also add +1 for each year company’s sales have increased. A...

What is the formula that I can use in Column C? I don't want to have to change any cell references as this data changes all the time so it will have to be smart enough to detect blank cells in column B and then place the subtotal in column C. Also, the subtotal in column C is only for a...

Hi Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have an issue with a large data set but will try to explain it the best I can. <o:p></o:p> <o:p></o:p> In my template, in column A, I have a measurement which continues all the way down to 1002...

Hi All, I am trying to convert a table that looks like this: Time; Event 1; Event 2 12:00; 0; 0 13:00 ; 0; 0 14:00 ; 10; 0 15:00 ; 4; 0 16:00 ; 5; 4 17:00 ; 3; 5 18:00 ; 5; 0 19:00 ; 0; 0 20:00 ; 0; 0 21:00; 0; 0 22:00 ; 0; 0 23:00 ; 1...