sumproduct

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » SumProduct

SumProduct

resolvedResolved · High Priority · Version 2007

Hashim has attended:
Excel Intermediate course

SumProduct

I would like to calculate the sum of the salaries for all people who live in Berks, has had a service greater than 5 years, and has a Rover 25 car, using the SumProduct function.

The purpose of using SumProduct is to make all values that are true=1 and false=0 hence we can calculate the SUM when we have 3 true values multiplied with the salary

RE: SumProduct

Hi Hashim

Thank you for your question

Having considered your problem I would recommend using a DSUM function. This function is a database function, which calculates the sum of a particular column depending on values contained in other contigous columns.
The function requires you to specify the following arguments

The area containing the data to be analysed
The column to be summed
The criteria range

The criteria range contains the headings of the criteria columns and the required values.

I have uploaded an example file for your information

Regards

Stephen

Attached files...

DsumExample.xls

Thu 4 Dec 2008: Automatically marked as resolved.

 

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:

Outlining - ungrouping rows or columns

Highlight want you want to ungroup and press ALT + SHIFT + right cursor arrow

View all Excel hints and tips


Server loaded in 0.09 secs.