PDA

View Full Version : Sumif and Sumproduct According to Multiple Criteria Function



Macha10
02-01-2008, 06:12 PM
I have four columns labeled
Name, Days Out, Pay Lost, Incentive

I would like to use a sumproduct and sumif formula for each name. I have four names, Tommy, Bobby, Ricky Lance.

I would like to do something like

sumproduct(days out: pay lost)/sumif(paylost, ">0", incentive) for each person Tommy, Booby, Ricky, and Lance. The problem is I cannot specify in the sumproduct and sumif that I only want to use the values that correspond to that one person. I have attached a picture and the excel. cells h3:i6 are the values that the vba function or equation should calculate.

Macha10
02-01-2008, 06:13 PM
here is the excel

Macha10
02-01-2008, 06:14 PM
tia

asingh
02-01-2008, 07:43 PM
Hi,

Attached is a sheet...with the solution..!

Macha10
02-02-2008, 11:44 AM
great thanks! I did not know you could use sumproduct in that way. This is such good information for me! Really appreciated!