Taking sum in query and x 16 before displaying results?

[wwgmr]

Hi all, I am trying to run a simple query that sums each column in table and then x it by 16 or better yet the average number from a column b result. So column a is Title that I am sorting by criteria and column b is average of the hours for that title. Column c-e are all different companies that I want to sum each and multiply by value in column b.

Is this possible?

Thanks for your help.

Eric

 

[KenWright]

Unless I am reading this wrong, and assuming your data is in say A1:E100 with headings in row 1, then are you simply after in cell C101 the following formula:-

=SUM(C2:C100) * AVERAGE($B$2:$B$100)

Then just copy C101 and paste it into D101:E101

Regards
Ken.............