Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · Low Priority · Version 2007
Louise has attended:
Excel Advanced course
why do you need to have the letter 'D' in front of SUM, AVERAGE etc when using database formulas?
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:Separate the year from a dateTo separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1) |
We'll call during UK business hours
Server loaded in 0.07 secs.