98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Excel
excel course - Excel
Resolved · Low Priority · Version Standard
Thu 3 Jan 2008, 10:17Delegate Muhammad said...
Muhammad has attended:
Excel Advanced course
Excel
How to do the aggregate formula, it is just like AVERAGE of marks but it is not AVERAGE FORMULA. Aggregate is something else, on the basis of which, selection of students are made in the Universities.
Fri 4 Jan 2008, 11:20Trainer Stephen said...
RE: Excel
Hi Muhammad
Thank you for your question
Could you define the "aggregate" function a little bit more.
I think you might be refering to some sort of weighted average. If this is the case then it might be possible to write the function for ourselves in VB
Regards
Stephen
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Counting Non Number Cells (Text)If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values. |
