Databse functions and Tabular functions

Hi Kwame,

Thank you for your question in STL's forum. My name is Ron and I am one of the instructors at STL.

Kwame, I believe you either attended a course with Jens or with Marius. They are busy delivering training at the moment, so can't reply.

Kwame, could you tell me which course and exercise you are referring to in relation to your query? I might be able to retrieve the answer for you. It would also be useful if you remember who your instructor was.

Please reply to this post and I will see what I can do.

Kind regards

Ron Oldeboom
Learning and Development Comsultant
STL-training

Hi Kwame,

I hope you are well. Thanks for your question. To create tabular data using database-type functions, I would actually use Sumifs, Countifs or Averageifs.

With Dsum, Dcount and Daverage, the criteria reference in the function makes it hard to copy down and across. Dsum, Dcount and Daverage are better for single cell results.

I hope this makes sense.

Kind regards
Marius Barnard
STL