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