=sumproduct(--(B1:b500="Total"),--(C1:c500="Asset"),H1:h500)

This will return the SUM of column H for each row where B=Total and C=Asset.
If there's only one entry to match those criteria, then this is all you need


"Frantic Excel-er" wrote:

Hi All...

I am trying to figure out what the best way to perform the following
function would be.
On overview - I am trying to have Excel look for the word "Total" in column
B, and the word "Asset" in column C, and if both of those items are
satisfied, I want it to return the value (which is a number)from column H....

1. Which function would do that for me?
2. What would the formula look like?

Thanks!!!