sumproduct

[tabspace]

I have the following data:

I would like to use sumproduct based on day of the week but also replacing the Hi, Mid and Lo with their correct values.

For example, for Paul, the total of his Mondays, should be 1*100+3*1+1*1

Any ideas?

 

[tabspace]

Re: sumproduct - advanced difficulty

Hi Barry,

I realized I would need to add another condition. Besides what I need, now I would like to make two tallies, one if it is towards a bonus and one if it isn't. In my example:
Susan would have:
Towards bonus: Monday: 50*1=51
Non bonus: Monday: 1*3+100*1=103

Is this possible?

Thanks!


Jim

 

[barry houdini]

You can keep adding more conditions if you want, so for Paul on Monday towards bonus try

=SUMPRODUCT((B$1:F$1="Monday")*(B$3:F$3="Yes")*SUMIF(H$2:H$4,B4:F4,I$2:I$4),B$2:F$2)

 

[tabspace]

Thanks!!

You can keep adding more conditions if you want, so for Paul on Monday towards bonus try

=SUMPRODUCT((B$1:F$1="Monday")*(B$3:F$3="Yes")*SUMIF(H$2:H$4,B4:F4,I$2:I$4),B$2:F$2)