Row meet multiple critera sum seperate column

[musikmanok]

First post here and looking for some help. I am in no way an Excel guru.

What's the easiest way to do the following:

Data in column A = "Bob"
and
Data in column B = "Tulsa"
and
Data in column C = "Poker"

If all 3 criteria in each row is met, then I want to sum the value of column H.

Hopefully I have explained this well enough. Let me know if you need additional clarification.

Thanks
Steven

[DonkeyOte]

Prior to XL2007 (intro. of SUMIFS) you're looking at SUMPRODUCT though note this is not overly efficient and you should avoid using large precedent ranges (entire column references [A:A] are not permitted for good reason)

=SUMPRODUCT(($A$1:$A$100="Bob")*($B$1:$B$100="Tulsa")*($C$1:$C$100="Poker"),$H$1:$H$100)

If you intend to use the above en masse or with huge precedent ranges I'd encourage use of an additional key column, eg:

I1:
="^"&$A1&"^"&$B1&"^"&$C1&"^"
copied down to I100

this way you can still use a basic SUMIF by simply combining the three criteria into a single string

=SUMIF($I:$I,"^Bob^Tulsa^Poker^",$H:$H)

given the significant improvements in efficiency of calculation (precedent range usage) we can use much larger ranges with the above construct.

also by encasing each term within a delimiter we can utilise wildcards in our SUMIF should we need to... eg: sum H where A begins with B, B = Tulsa and C = Poker

=SUMIF($I:$I,"^B*^Tulsa^Poker^",$H:$H)

[musikmanok]

Perfect. thank you!