=SUMPRODUCT(--(A2:A100="John"),--(B2:B100="Smith"),C2:C100)

--
HTH

Bob Phillips

"davidm_ba" wrote
in message ...

Hi,

I a bit of an Excel newbie, and can't figure this one out. Maybe it's
easy for someone out there?

I need to be able to do a SUMIF based on 2 seperate columns in order to
put a sum of values from one sheet into a summary on another.

For example,

Sheet1
A B C
John Smith 40
Joe Bloggs 38
John Smith 24
Jane Smith 36

Sheet2
X Y Z
John Smith 64


So in Sheet2, the total (col. Z) is calculated from Sheet 1 col. C,
based on BOTH A matching X and B matching Y.


Thanks for any help you can give.

Dave.


--
davidm_ba
------------------------------------------------------------------------
davidm_ba's Profile:
http://www.excelforum.com/member.php...o&userid=25811
View this thread: http://www.excelforum.com/showthread...hreadid=392096