I am trying to write a function that returns a value that meets certain criteria. I have a worksheet that has about 40 rows and I want to return the number to a different worksheet that meets two criteria. What function would you recommend.

Ex if value in column A = Tree and value in column B = 1999 then total and show on a different worksheet.

Hope that is clear enough.

Thanks

Is this what your after?

=SUMPRODUCT((A1:A40 = "Tree")*(B1:B40 = 1999)*(C1:C40))

where A has to equal Tree, B has to equal 1999 and C is a Number
This sums the numbers when A is True and B is True sum the values in C

David

Thanks that perfect

Just as a reminder, when you use SUMPRODUCT, you have to specify the rows. You cannot use A:A (as you can in other functions), it has to be A2:A50 or something like that.