sumif across multiple sheets in excel 2007 based on a conditio Biff, Neat solution Could you give a brief explanation as to what's happening in the FREQUENCY bit in your: =INDEX(FREQUENCY(Saturday:Friday!A1:A10,0),2) Thanks -- Max Singapore --- ... 23 May 2010 23:24 Using Custom Views with Protected Worksheets I'm using custom views and I have 19 tabs that reference each other - one tab has a graph and a pie chart. As soon as I try to protect any of the worksheets I cannot use custom views - a dialog box comes up "Some view settings could not be applied". Is there a way around this? I'm using Excel 2003. -- T... 13 May 2010 00:45 Ziping excel 2007? My company recently upgraded to office 2007. With excel 2003 I could zip a 30-35mb file to less than 5mb. The same kinds of files/data in 2007 only zip from 30-35mb to 25-28mb. Is there a different software that can comprress better? Is there a setting in Excel 2007 i can change? thanks ... 12 May 2010 21:27 Cell Function/Font Color Is there a CELL Function that you can identify the color of a font with? I would like part of a macro to make a decision based upon the color of the font in a particular cell. ... 12 May 2010 19:14 Zero and Null Sum Function I have the following formula in place: =IF(SUM(I14:N14)>1,SUM(I14:N14),"") The problem I have is when zeros are legitimately entered in the reference fields the sum formula leaves the cell blank instead of summing the cells across to display a zero. In essence how do I get the field to be blank when the re... 12 May 2010 19:14 SD03*10 -how do I just get the numbers at the end in cell after * ,I have SD03*10 in a cell and I want in a separate cell, just to have the numbers after the *. Obviously with lots of data, the digits after the * could be 1 to many characters so I cannot use the Left function. Any help would be greatly appreciated so I don't waste any more time! ... 13 May 2010 00:45 Finding next number in a series I have a series of numbers in one column (sample): 1 2 4 5 7 16 What formula would find the smallest available number? In other words how would I find "3"? ... 12 May 2010 17:00 Combination of IF, AND, and COUNTIF; need help Hi, I am trying to make a calculation that will take Pass/Fail values of P or F and give me an overall value of P or F. There is also an issue if a value is Not Tested, NT. For example, I have three levels of requirements (parent, child, and grandchild). Parent is level 1, Child is level 2, and Grandchild is ... 13 May 2010 17:10 Time Format Question Hello, I currently have time entered like this: 173517 90207 I need to look like this: 5:35 p.m. 9:02 a.m. I've done a ton of research but nothing has worked so far. Thank you. ... 13 May 2010 00:45 IF formula help? Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the name matches one of the names in Column D I'd like it to put a Y in Column B. I tried =IF(A2,VLOOKUP(\$D\$2:\$D\$1631,"Y","N")) but it doesn't work. -- Thank... 12 May 2010 12:31