Excel Guru

I have 15 values in a spreadsheet and I want to find the highest 10 values from that 15 and total them. If there is a blank then no return was made. Please refer the attached snap shot of excel for more clarity. =SUMIF(3:3, ">=" & LARGE(3:3,10)) For any queries kindly pos t your comments and questions.

Sometime you required to hide the formula  in excel sheet. Firstly, un-protect your sheet and right click the cells where you want to hide the formula  and click 'Format cells'. On the protection tab select the 'Locked' checkbox and then re-protect your sheet and the formula will not show up in the formula bar.

If excel in your system work slow kindly follow below steps. 1. Reduce as many array formulas as possible 2. Use Conditional Formatting as minimal as possible - use it only for exceptional reporting 3. Clean (clearcontents and delete) excess rows and excel columns in your data sheets 4. If you have multiple pivot tables coming out of same data area, then try to ensure that they all use the same Pivot Cache 5. Avoid using Volatile Functions like VLOOKUP, TODAY(), etc. in your file 6. Unless absolutely necessary, try to keep other workbooks closed while working with this large file

Would you like a way to remove those green error checking triangles from worksheet cells, yet retain error checking? Go to File, Options, Formulas, Error Checking. Leave the “Enable background error checking” box checked, and change the Indicate errors using the color (default is green) to white. Of course, this only works if the cells are white. To turn off the error checking and the green triangles, change the “Enable background error checking” box to unchecked.