Hi,
I recently posted about using SUMPRODUCT to check for a month, as well as two other criteria in two other ranges. The post is here - http://www.mrexcel.com/forum/excel-questions/691766-using-sumproduct-adding-month-criteria.html
However, using the same formula in Excel 2003:
=SUMPRODUCT(--(Correspondence!$B$36:$B$999=admin!$B$15),--(Correspondence!$C$36:$C$999=Correspondence!A8),--(MONTH(Correspondence!A36:A999)=2))
I have been trying to figure out how I can do the following - I want to check down column C:C as above but to see if it matches Correspondence!A8:A15, or maybe A28:A35 for another formula.
Again I have found some pointers elsewhere and tried to them, tweak them, adapt them but so far I cannot get it to work.
So, to clarify, I want the above formula to still check Correspondence!B36:B99 for ADMIN!B15,
I still want it to check the month in Correspondence!A36:A999 but instead of matching just Correspondence!A8, I want it to check for Correspondence!A11, or A12 or A13 or A14 or A15 and populate the cell with the total of all of these 5 things for a certain month by a certain person.
Any ideas?
Stu
I recently posted about using SUMPRODUCT to check for a month, as well as two other criteria in two other ranges. The post is here - http://www.mrexcel.com/forum/excel-questions/691766-using-sumproduct-adding-month-criteria.html
However, using the same formula in Excel 2003:
=SUMPRODUCT(--(Correspondence!$B$36:$B$999=admin!$B$15),--(Correspondence!$C$36:$C$999=Correspondence!A8),--(MONTH(Correspondence!A36:A999)=2))
I have been trying to figure out how I can do the following - I want to check down column C:C as above but to see if it matches Correspondence!A8:A15, or maybe A28:A35 for another formula.
Again I have found some pointers elsewhere and tried to them, tweak them, adapt them but so far I cannot get it to work.
So, to clarify, I want the above formula to still check Correspondence!B36:B99 for ADMIN!B15,
I still want it to check the month in Correspondence!A36:A999 but instead of matching just Correspondence!A8, I want it to check for Correspondence!A11, or A12 or A13 or A14 or A15 and populate the cell with the total of all of these 5 things for a certain month by a certain person.
Any ideas?
Stu