excel course - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course - Excel

excel course - Excel

resolvedResolved · Low Priority · Version Standard

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.

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 courses

 

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
What does 'Resolved' mean?

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.

View all Excel hints and tips


Server loaded in 0.08 secs.