Excel Advanced - V-Lookups and Formulas

Hi Alex,

Thanks for your question.

If I understand the question, I think that the SUMIF should give you what you need. It has 3 parts, the last is the column of numbers you want to add up, the second is the condition you want to use and the 1st is the column the condidion applies to. The 1st and 3rd arguments must be the same length.

Suppose you type the name into cell A1 and you want the total number of days in B1. You also have the following 6 columns of information somewhere else in the spreadsheet, not necessarily beside each other: names_pre, days_pre, names_on, days_on, names_post and days_post.

the formula in B1 is:

=SUMIF(names_pre,A1,days_pre)+SUMIF(names_on,A1,days_on)+SUMIF(names_post,A1,days_post)

Hope this sorts out your summary!

Regards

Clare