Hello! Thanks for attempting to help! :D
Alright, so I am fairly well versed in excel but this just confounds me!
First just let me describe my situation:
I am working across several sheets in a single book (5 to be exact) and am doing an averaging of call times so the top brass can just look at one sheet and see everyone’s averages. I had this done already with the formula =IF(SUM('WEEK 1:WEEK 5'!C6)=0, "", AVERAGE('WEEK 1:WEEK 5'!C6)) so that it would average but if there was nothing to average then that cell would remain a "" and therefore not be averaged in the other formulas for that sheet (on the averages sheet there are other formulas that would get a little skewed if a zero showed up and I didn't like the ref error or whatever it was).
But now they want the numbers to be ordered from greatest to least on the sheets being used to average, and separated into a few groups (groups I can do, and ordering I can do) however, this will mess up the averages when the cell it needs is in a different location.
So I need a formula, or formulas (I'll just hide them if it needs more than one cell, no big deal) that will only display a "" when no value is present, that will only average a cell from another sheet that’s on a row that has a certain value, let’s say value 7012 but will always be in the same column (let’s say it has to use a cell that =7012 in column A6:A15) but could be on any row in that column.
I can explain more if needed, or post a sample of what it looks like currently if needed.
Thanks so much for your help!
Bookmarks