Using SUMIF function with multiple criteria for Aging
Hi,
I'm not quiet sure this is what you are looking for but anyways.
Maybe this will help you on the first one. This Sumproduct will give
you the sum of the combinations where TRN is Rcp and MO = 1
=SUMPRODUCT(--(A2:A21="Rcp"),--(B2:B21=1),C2:C21)
If you want the sum for month 2 and 3 you could just make two and add
them.
Regards,
Bondi
|