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
DsumExample.xls
