It work perfectlyHi:
one way is to use this array formula
=SUM(IF(($A$4:$A$12=A18)*($C$2:$G$2=B$17),$C$4:$G$12))
Thanks
Thanks for the formula. I have one more criteria and not sure if you can help or not.Another non-array formula possible………..
In B18, copy across and down :
=SUMPRODUCT(($A$4:$A$12=$A18)*($C$2:$G$2=B$17),$C$4:$G$12)
Regards
Bosco
Thanks for the formula. I have one more criteria and not sure if you can help or not.
My problem is I want to sum all record in the most left column each week base on region.
Please view attached file for more detail.
Thanks,