Excel/Expert Profile

Douglas M. Smith

U.S.
On Vacation
returns 11/17/2009
Expertise

I specialize in solving formula, feature and structure related problems. I know many tricks to help make your spreadsheets and processing more efficient.

Past/Present Clients

Gannett, Fannie Mae, Pepsi, Nortel, Procter & Gamble, BellSouth, Blue Cross Blue Shield of NC, NC Central University, GlaxoSmithKline, Maintenance Excellence Institute, AAI Pharmaceuticals, Blue Cross Blue Shield of SC, Brainbench.com

What do you like about this subject?

Excel is the most under-utilized application in the world. I love showing people how to turn it loose.

Something interesting about this subject that others may not know:

Check out my Excel Web Seminar on June 25: http://goto.webinarinstitute.com/go/8742 My website: www.abundant-solutions.com

Something controversial or provocative about this subject

Life's too short to re-key data.

Average Ratings

  • Knowledgeability 9.92
  • Clarity of Response 9.93
  • Timeliness 9.98
  • Politeness 10.0
  • Number of Questions (in Past 24 Hours) 0
  • Max Questions to be Asked (in 24 Hour Period) 2
  • Total Questions (since joining AllExperts) 1634
  • Volunteer Since 2002-12-20
  • Prestige Points 13116

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    T = Timeliness    P = Politeness
UserDateKCTPComments
Hilde09/17/0910101010Thank you so much Douglas. That was .....
fkwan08/20/0910101010Hi Thank you very much for your .....
Setiadi08/19/0910101010Thanks Doug! Your Formula is very useful .....
fkwan06/05/0910101010Thank you very much for your great .....
John06/04/0910101010Ha! It works. Thank you so much .....

Recent Answers from Douglas M. Smith

2009-10-03 Excel Formula - A doozie:

Hi Bruce, Sorry for the delay, I've battling the flu. Time values in Excel are really just the decimal part of a day. Examples: 6:00 am is 0.25, noon is 0.5. To convert a time to the decimal number

2009-09-15 lots of ifs:

Hi Hilde, The easiest solution would be to select all the date cells and use the Replace command (Edit menu) to replace all the #VALUE! entries with nothing. Then your formula should work as-is. Otherwise

2009-08-19 excel 2007 Conditional formatting for dates:

Hi Dan, You will need to set up three cases to do this. In the Conditional Formatting dialog box, set it up for three cases and select the "Formula Is" option for all three. Use the following formulas

2009-08-19 Excel formula problem:

Hi, You will need an array formula for this. The formula in cell F5 would be: =SUM(IF($B$3:$B$15=E5,IF($A$3:$A$15=$F$2,$C$3:$C$15,0),0)) but instead of using Enter, you will need to use Control+Shift+Enter

2009-08-18 sumif with partial keyword:

Hi Setiadi, If the first line is on row 1, the formula for cell D1 would be: =SUMIF($A$1:$A$5,"*"&C1&"*",$B$1:$B$5) The asterisk (*) character is a wildcard and in this formula, it looks for the

 

Ask A Question

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:

Ask Experts

Volunteer

©2009 About.com, a part of The New York Times Company. All rights reserved.