Here's the reply posted in your earlier thread:
------------------------------
Assuming your cols A, B, C data is in Sheet1,
say from row2 down to row1000
Try in another sheet, say, Sheet2:
------------------------------------
Put in A2: Jan
Put in B2: completed
Put in C2:
=SUMPRODUCT((Sheet1!$A$2:$A$1000="Jan")*(Sheet1!$B$2:$B$1000="completed")*Sh
eet1!$C$2:$C$1000)
C2 will return the total amount of "completed" Jan loans,
ie the total of amounts in col C
for which col A = "Jan" and col B = "completed"
And if you have yet other combinations of values
in cols A & B to similarly evaluate,
(e.g.: Jan - denied, Jan - withdrawn, Feb - completed, etc)
just put these in A3 & B3, A4 & B4, etc viz. down cols A & B.
Then just copy C2 down the col C to calculate all the corresponding results.
Amend the range references to suit,
but note that the 3 ranges must remain identical, viz.:
Sheet1!$A$2:$A$1000
Sheet1!$B$2:$B$1000
Sheet1!$C$2:$C$1000
and you cannot use complete cols, e.g.: A:A, B:B, C:C in sumproduct
