98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » SumProduct
SumProduct
Resolved · 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...
Thu 4 Dec 2008: Automatically marked as resolved.
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:Outlining - ungrouping rows or columnsHighlight want you want to ungroup and press ALT + SHIFT + right cursor arrow |