Multiple Data To Retun Single value Help Req

[Curdster]

Can any one help here. I think I need to link different formulas here and don't want to use a pivot table. The columns run to row 200 and I have 10 separate spreadsheets. I want to create a new file, a master consolidated view

Each row represents 1 client

Column A Contains Yes or No
Column B Contains the Source (i.e Post, Email, Phone)
Column C contains a range of different dates ie when customer made contact
Column D Contains a currency value.

So the question I need to answer is; Return a sum of Column D for those values who's row attributes are Yes, Post and date of current day +5.

In simple terms who can I contact in 5 days time and what is the expected value.

I have added current date in cell E1. F1, F2, F3, contains text Post, Email, Phone.

Can anyone help me?I have been a this for days I think I am confusing myself.

 

[Curdster]

Anyone?

 

[PaddyD]

Hi - welcome to the board.

Depending on what you mean by "date of current day +5", perhaps:

=sumproduct(--(a2:a200="Yes"),--(b2:b200="Post"),--(c2:c200>=today()+5),d2:d200)

 

[Curdster]

Paddy this is superb. Thank you. Can you tell me how change the date part of the formula so that it returns values which are always within the next 5 days not greater than equal to or less than. i.e if today is 01/02/2014, it would return the sum of values where dates are, 01/02/2014, 02/02/2014, 03/02/2014, 04/02/2014, 05/02/2014.

 

[PaddyD]

=sumproduct(--(a2:a200="Yes"),--(b2:b200="Post"),--(c2:c200>=today()),--(c2:c200< =today()+5),d2:d200)