Try something like this:

With your sample data in A1:C6

D1: =SUMIF(A1:A6,"Region 1",C2:C7)

Notice the second reference is offset one row from the first reference.

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Jasmine" wrote:

Is it possible to use the Sumproduct formula to search for a particular word
and grab the amount in the next column, but 1 row down? For example, I would
search for region 1, but want to grab the figure in the total loans column
next to Consumer.

Region Loan Type Total Loans
--------- ------------ --------------
Region 1 Commercial 150000
Consumer 75000
Region 2 Commercial 90000
Consumer 145000

If this is possible, how would the formula be written? Thank you so much!