With made up data on my worksheet it functions just fine. My first guess is
that your values for "Total" & "Assets" may have spaces before or after.

To troubleshoot: Find one of the cells that you think contains "Total" and
in an empty cell nearby type

="Total" = that cell

if you get a true, try the same tst with "Assets". If that comes back true,
then I'd suspect the values in col H aren't really numbers, but text
representations of numbers.

After that, I'm out of guesses


"Frantic Excel-er" wrote:

Hi Duke...

copied the formula, and it is still giving me a "0" value.....
any suggestions?

"Duke Carey" wrote:

=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!!!