Hi

I assume you want to calculate total based on values in Sheet2

In Sheet1 use this formula (headings in row 1):

=Sumproduct(--(Sheet2!A13:A49=A2), --(Sheet2!B13:B49=B2),Sheet2!
C13;C49)

Hopes this helps.
....
Per


On 16 Jul., 01:11, Curtis wrote:
SHeet 2

Column a (rows 13 thru 49) contains products
COlumn c (rows 13 thru 49) contains vendor
Column Q (rows 13 thru 49) contains spend

Sheet 1

Column a contains products
column b contains vendor
column c contains spend

I need a formula that will calculate the toatal spend by product by vendor

thanks