Returning data from a different sheet dependent on two conditions

[rockp3nguin]

Hello!

I am constructing a sheet which attempts to summarise lots of data from another sheet.
I'm going to give an example of two sheets below which simplifies the problem because I'm finding it impossible to describe!

e.g.

Sheet 1 looks like this:

A --------- B --------- C

Dave------Summer-------4
Mary------Winter--------2
Tom-------Winter--------3
Dave------Winter--------2
Tom------Summer-------1


Sheet 2 summarises like this:

Name-------Winter------Summer

Dave----------2-----------4
Tom-----------3-----------1
Mary----------2-------("" / BLANK)

I can use vlookups pretty well, and have used these combined with ISNA before as well to return column 'x' from a data rnage on another sheet.

The problem I'm having here is I can't figure out a way to get the second sheet to check for the 'season' as well as the name of the inidividual.

Any ideas?

Many thanks in advance for any assisstance, even reading this is much appreciated!

Andrew.

[hemesh]

Hello and welcome to the forum
Try Sumifs

[hemesh]

find the attached
Adjust your range according to your base data!


Always post a sample book with expected results...
(To attach a sample book go to advanced and select paper clip icon)

[jd16]

Please upload a workbook with a clear explanation in the sheets itself by highlighting the cells, rows or columns where you want to get the help for with a remark if needed.


Regards