Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

ResolvedVersion 2007

Wed 13 Aug 2008, 16:33 Delegate Louise said...

Louise has attended:
Excel Advanced course

Excel

why do you need to have the letter 'D' in front of SUM, AVERAGE etc when using database formulas?

Tue 19 Aug 2008, 13:46 Trainer Mark said...

RE: Excel

Hi Louise

Thanks for you question, the reason for using D in the formula is because it allows you to use certain cirteria to search within a database

without the D your formula just wont work within a database

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Go to source of a cell