Sumif with 2 sets of criteria

=SUMPRODUCT((Arange="Yes")*(Brange="Monday"),Drange)

For more multiconditional counting & summing, see:

http://www.mrexcel.com/board2/viewtopic.php?t=59063

If you haven't already done so... you ought to add-in and use the Conditional Sum Wizard. It provides a step-by-step guide for the construction of conditional array formulas such as...

{=SUM(IF(range1="Yes",IF(range2="Monday",range3)))}

Why write the formula when Excel will do it for you?

Note: Array formulas must be entered using the Control+Shift+Enter key combination. The outermost braces, { }, are not entered by you -- they're supplied by Excel in recognition of a properly entered array formula. For

I am trying to use the Conditional Sum wizard but am experiencing problems. I have a named array which has all the days of the month across the top, names of all staff down the first column, which department they work in in the second column and their shift start time is entered into the body of the table.

I have been able to use the Conditional sum wizard to display how many staff we have in each department for each day for each different start time for the dates between 10/11 and 30/11 but when I follow the exact same procedure for anything out with these dates the error message reads that I have a randionized value which will have to be removed.

I can not find these figures based on randonized values. I have deleted all the data except the date at the top of the column and I still cant get it to work!!

Any tips?

It must have had something to do with the way the dates were formatted. I have now fixed the problem by removing the dates, using the wizard and then hard typing the dates back in.