Originally Posted by

**davidm_ba**
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.

## Bookmarks